Seperating 1 column into 2

  • Thread starter Thread starter Lance
  • Start date Start date
L

Lance

I have a column in the format - firstname lastname..... I
would like to create 2 columns.. firstname in one column,
lastname in 2nd column. Is it possible? If so, how??

Thanks in advance
 
Lance, 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 & 97
** remove news from my email address to reply by email **
 
Back
Top