Splitting names
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.
|