<<<"Note also that if you have any data to the right of column A and use
this
technique, that data will be overwritten by the text to columns
maneuver."

This *only* happens if you *don't* use the destination box in the 3rd window
of the TTC wizard, and allow the default destination (original data column)
to remain in force!

The separated data columns can be directed to *any* range (column and/or
row) in the WS.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Dave F" wrote in message
...
Select column A, and then go to Data--Text to Columns and use space as
your
delimeter. Note that if you have three names (John Smith, Sr.) your data
will be split into three columns.

Note also that if you have any data to the right of column A and use this
technique, that data will be overwritten by the text to columns maneuver.
Therefore make sure you have plenty of blank columns to the right of the
colum you are splitting into multiple columns.

Dave

--
Brevity is the soul of wit.


" wrote:

I have the name, John Smith, in column A. Is there a way to keep John
in column A, but move Smith to column B (without re-typing it, of
course.)

Thank you.