How do I sepearate first and last name to two cells from one cell?
How do I sepearate first and last name to two cells from one cell?
Użytkownik "WilsonLA" <[email protected]> napisał w
wiadomości news:[email protected]...
> How do I sepearate first and last name to two cells from one cell?
try to use text to column
mcg
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" <[email protected]> wrote in message
news:[email protected]...
> How do I sepearate first and last name to two cells from one cell?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks