I have thousands of data on a column that is similar to
1651651465,"15654"
41654544,"4814"
they are all in a single column (like A1, A2, A3,....)
I want to save the number before ,
to A1(A2,A3,A4...) and the number inside ""
to B1 (B2,3,...). how can I do it?
then it will be like:
A B
1 1651651465 15654
2 41654544 4814
3 etc
4 etc
If you know how to do it in open office, I can use open office then save it as MS excel.