Splitting names

G

goldcomac

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

PCLIVE

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

HTH,
Paul
 
G

goldcomac

Very easy to do. Thanks.

Chip



Dave said:
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
Click to expand...
 
R

RagDyer

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