I have a spreadsheet with about 2000 rows. In column B of the spreadsheet
there is a lot of information that needs to be parsed into serveral new
columns. I do not want to use the Text to Column option because it only
allows 1 row at a time. Here is an example of text found in column B:
John Smith Jr 123456789 city state 54555 0003434343
Any suggestions would be greatly appreciated!
thank you!