Hi

It's easy until all words (strings separated with a single space) must be in
different columns.
P.e. insert enough empty columns after column A, select the column (or a
range there), and then from menu TataText to Columns..., and proceed with
wizard.

For your 2 example, it would be trickier. When the number of different
multi-word street names is limited, you may use ReplaceAll to replace 'Main
Street' p.e. with 'Main_Street' everywhere in colum, and repeat the process
for all strees alike. After that you can apply TextToColumns operation, and
then ReplaceAll to replace all "_" with single space.


Arvi Laanemets


"Baffled" wrote in message
...
I have two columns on my excel sheet (13000 records)

Column A is: John Smith
I want to put the John in Column A and Smith in Column B

Column B is: 1240 Main Street
I want to put 1240 in Column C and Main Street in Column D

Do-able?