stupid question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a spreadsheet that the last person working on it put last name and
first name in the same cell i would like it to have a last name column and a
first name column.
is it possible to split the contents with out having to retype it all.

P.S. there are over 1000 entries ;O)
 
Thanks so much that works great except it doesnt line up correctly.
some still have the middle initial and some rows bring over the first letter
of the last name.
very confusing but i will keep trying
 
i figured it out
thanks so much

Kimberly said:
Thanks so much that works great except it doesnt line up correctly.
some still have the middle initial and some rows bring over the first letter
of the last name.
very confusing but i will keep trying
Click to expand...
 
Kimberly, have a look here and see if something there will do what you want
http://www.cpearson.com/excel/FirstLast.htm
--
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 2002 & 2003
 
Back
Top