Cell Help

  • Thread starter Thread starter cufc1210
  • Start date Start date
C

cufc1210

I have a spreadsheet set up like below


A
1 601,'1'
2 60219,'1'
3 60220,'2'

is there a way of getting rid of the punctuation and seperating the numbers
e.g in cell A1 at the moment i have 601,'1' i would like in cell A1 601 then
in cell A2 1 and so on for A2, A3 etc.

Is there a way to do this for every cell as there are about 1000 cells set
like this or will i have to do it mannually for every cell

Hopefully this makes sense

Thanx in advance
 
Try Text to Columns with a Delimiter of comma (,) and a Text qualifier of
quote (')

Regards,
Fred
 
Paste this formula in B1
=LEFT(A1,FIND(",",A1)-1)
This will get you the 601
Copy the B1 cell and paste it to the remaining cells of B Column depends on
A Column Data.

Paste this formula in C1
=SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND(",",A1)),"'","")
This will get you the 1.
Copy the C1 cell and paste it to the remaining cells of C Column depends on
A Column Data.

Remember to Click Yes, if this post helps!
 
Back
Top