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