Seperating text in a cell

[Guest]

Hi

I have a column that contains the first and last name of parents. I want to seperate the first name and put it into it's own column. How can I do this

Thank you

 

[Paul B]

Jennifer, 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 97 & 2000
** remove news from my email address to reply by email **

Hi ,

I have a column that contains the first and last name of parents. I want

to seperate the first name and put it into it's own column. How can I do
this?

 

[Frank Kabel]

Hi
try 'Data - Text to columns'
You may also have a look at
http://www.cpearson.com/excel/FirstLast.htm