I have been given some data in an excel spreadsheet which looks like it has just been pasted from a txt file as it has 800 rows of data but all the data is contained in column A separated by commas (,) & the squiggly thingy (~).
Example
They cannot supply me with the original txt file so I can't use the delimiter function.
I need to separate this one line of data currenly contained in column A into separte columns across the spreadsheet so I can work with the data.
Is there a way to tell excel to copy the characters between the (,) & (~) into separate columns?
Many thanks
Jac
Example
Biell~Alfre ~18/04/1907~1395 Biell,Alfre Lionel,(18/04/1906),(09/03/2001),Nazae,Rediffe,420
They cannot supply me with the original txt file so I can't use the delimiter function.
I need to separate this one line of data currenly contained in column A into separte columns across the spreadsheet so I can work with the data.
Is there a way to tell excel to copy the characters between the (,) & (~) into separate columns?
Many thanks
Jac