Separating the data in one column into two columns

[Bryan]

I have a workbook containg 800+ names in it in which the
name column contains both first and last names. Can the
data be divided into first and last and put into 2
sepatate columns?

 

[Paul B]

Bryan, 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 **

 

[deh240966]

-----Original Message-----
I have a workbook containg 800+ names in it in which the
name column contains both first and last names. Can the
data be divided into first and last and put into 2
sepatate columns?
.
highlight column, select DATA, TEXT TO COLUMNS, ensure

DELIMITED is selected. Click on NEXT. Tick SPACE. Click
on NEXT. Click on FINISH