Hello! Thank you in advance if you read this, or know how to do this...
I have a table that I have imported to Excel from a web database, but I need to break up a string of data, that could have zero to ten first and last names I want to get out of that cell... the only consistent way to know the breaks between names is a single "|" character spaced between names... for example:
John Smith | Jane Smith (2 names)
John Smith | Jane Smith | Joe Smith (3 names.... ad inifinitum)
Is there an easy way to program that break? There are also corresponding Business titles with that... but once I get set, I could figure that out...
I could do it manually, but I would like to see if there is a way to get it out first... THANK YOU!!!!
I do this kind of thing everyday as the database we use churns out comma delimited files(which excel doesn't recognise as csv's). This wizard also comes up when you try to open a text file which excel doesn't recognise.