Spliting a column

[Guest]

I have a field that contains first name and last name
combined in one column. Is there a way to split this
into two columns, one containing the first name and one
containing the last name, perhaps by using the space
between the first and last name?

Thanks in advance for your advice

Bill

 

[ElsiePOA]

Assuming you have only First and Last names (and not any middl
initials) the easiest way is to highlight the column and use Data
Text to Columns, using the space as the delimiter.
:cool

 

[Paul B]

Have a look at data, text to columns
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Guest]

Thank you very much. Worked like a charm.

-----Original Message-----
Have a look at data, text to columns
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **




.