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.

Select column A
Then select Data-Text to Columns.
Delimited-Next
Check next to Space.
Finish.

HTH,
Paul

wrote in message
oups.com...
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.

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.

Very easy to do. Thanks.

Chip



Dave F wrote:
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.

<<<"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.