Separating the data in one column into two columns

  • Thread starter Thread starter Bryan
  • Start date Start date
B

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?
 
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 **
 
-----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
Click to expand...
DELIMITED is selected. Click on NEXT. Tick SPACE. Click
on NEXT. Click on FINISH
 
Back
Top