Data-->Text to Columns-->Delimited-->Check Space & Other-->~
This is a discussion on Delimiting data in Excel within the Excel Questions forums, part of the Question Forums category; I have been given some data in an excel spreadsheet which looks like it has just been pasted from a ...
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 (~).
They cannot supply me with the original txt file so I can't use the delimiter function.Biell~Alfre ~18/04/1907~1395 Biell,Alfre Lionel,(18/04/1906),(09/03/2001),Nazae,Rediffe,420
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?
That did the trick.
I knew there would be a quickie fix!
Just for future reference, not trying to be a jerk, it is a tilde (easier to type than squiggly thingy).the squiggly thingy (~).
Brian is now done hijacking the thread.
St. Francis of AssisiStart by doing what's necessary; then do what's possible; and suddenly you are doing the impossible.
Try openning it in excel. Save it as a .txt file.
File>Open>(change file type to all types)>Select the file and instead of clicking open, click the little arrow next to it... select 'Open and Repair'>Repair>Delimited... etc etc
Hope that helps.
Pennysaver... there is a reason you're an MVP and I'm a regular.
Thank you Brian.