Text to Columns alternative
 

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!

Text to Columns alternative
 

Hi Kimberly

allows 1 row at a time

Select all cells in the column first before you use Data Text to columns



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kimberly" wrote in message ...
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!