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)

Select the cells with names in and then:-

data|text to columns and use the wizard

Mike

"Kimberly" wrote:

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

"Mike H" wrote:

Select the cells with names in and then:-

data|text to columns and use the wizard

Mike

"Kimberly" wrote:

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)

i figured it out
thanks so much

"Kimberly" wrote:

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

"Mike H" wrote:

Select the cells with names in and then:-

data|text to columns and use the wizard

Mike

"Kimberly" wrote:

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)

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

"Kimberly" wrote in message
...
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)