I have a query suppose I have JOB# 12221, 300 times in a row i want to remove just JOB # from all the 300 rows,which excel command should I use. Kashif can u provide me the excel formula thanks
Kashif Khan
(Senior Financial Analyst/ Web Developer/Illustrator/Social Activist)
(78 Points)
Replied 09 April 2012
@ Farheen Sultana,.....plz send me 1 screen shot of your data, coz 1 can remove or delete or arrange duplicate from several ways..so if u can provide 1 screenshotof your excel sheet,, i vil drive a definite solution,,if you hav any queries how to take screenshot ..dont hesitate ,,i wil send screenshot software..
thnxx dear..
Chandan Kumar
(Strategy Analyst)
(384 Points)
Replied 10 April 2012
@ Farheen - Use Text to Column with "fixed widtth fields'. This will separate the number part in a different column from where u can do whatever u want...
Hope it helps.
Kashif Khan
(Senior Financial Analyst/ Web Developer/Illustrator/Social Activist)
(78 Points)
Replied 19 April 2012
plz go through...