How do I sepearate first and last name to two cells from one cell?

WilsonLA, have a look at data, text to columns, post back if you need more
help with it
--
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

"WilsonLA" wrote in message
...
How do I sepearate first and last name to two cells from one cell?

U¿ytkownik "WilsonLA" napisa³ w
wiadomo¶ci ...
How do I sepearate first and last name to two cells from one cell?

try to use text to column
mcg

Select your column of names
data|text to columns
delimited, by space

This will work nicely with two names--maybe exactly the way you want with
multiple names.

WilsonLA wrote:

How do I sepearate first and last name to two cells from one cell?

--

Dave Peterson

Maybe NOT exactly the way you want with multiple names.

I left out NOT.

Dave Peterson wrote:

Select your column of names
data|text to columns
delimited, by space

This will work nicely with two names--maybe exactly the way you want with
multiple names.

WilsonLA wrote:

How do I sepearate first and last name to two cells from one cell?

--

Dave Peterson

--

Dave Peterson