Dividing first & last names?

[Digital2k]

Is it possible to divide first and last names that have a space between them
is one cell and put copy them to two separate cells?
Thanks,
Digital2k

[MartinW]

Hi Digital2k,

Data>Text to Columns will do that admirably.

HTH
Martin

[Digital2k]

Thank you Martin,
but I'm not an expert. I'm not clear on what I'm supposed to do with this.
The Full name is in column (A) I want the first name in column (B) and the
last name in column (C).
Where would I use Data>Text at?
Digital2k

"MartinW" <[email protected]> wrote in message
news:[email protected]...
> Hi Digital2k,
>
> Data>Text to Columns will do that admirably.
>
> HTH
> Martin
>

[daddylonglegs]

Data > Text to columns will keep the first name in column A and move the second to column B.

If you still want to retain the full name in column A then copy column A to column B, select column B and use Data menu > Text to columns option with space as delimiter.

Alternatively, using formulas, in B1

=LEFT(A1,FIND(" ",A1)-1)

and in C1

=REPLACE(A1,1,FIND(" ",A1),"")

[MartinW]

Hi Digital2K,

Highlight all of your names in column A.
Goto Data>Text to Columns.
In the first page of the wizard select delimited then click next.
In the second page of the wizard check space (make sure all other
options are unchecked.) then click next.
In the third page in destination put $B$1 and click finish.

These directions are for Excel 2000, if you have a different version
the process may be a little different but the basics should be the same.

HTH
Martin






"Digital2k" <[email protected]> wrote in message
news:[email protected]...
> Thank you Martin,
> but I'm not an expert. I'm not clear on what I'm supposed to do with this.
> The Full name is in column (A) I want the first name in column (B) and the
> last name in column (C).
> Where would I use Data>Text at?
> Digital2k
>
> "MartinW" <[email protected]> wrote in message
> news:[email protected]...
>> Hi Digital2k,
>>
>> Data>Text to Columns will do that admirably.
>>
>> HTH
>> Martin
>>
>
>

[Bob Phillips]

Select the column, go to Data>Text To Columns, click the delimited button,
check space delimiter box, and Finish

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Digital2k" <[email protected]> wrote in message
news:[email protected]...
> Thank you Martin,
> but I'm not an expert. I'm not clear on what I'm supposed to do with this.
> The Full name is in column (A) I want the first name in column (B) and the
> last name in column (C).
> Where would I use Data>Text at?
> Digital2k
>
> "MartinW" <[email protected]> wrote in message
> news:[email protected]...
> > Hi Digital2k,
> >
> > Data>Text to Columns will do that admirably.
> >
> > HTH
> > Martin
> >
>
>

[Digital2k]

Thank you to all!!
Took awhile but I'm learning thanks to this great forum.
Digital2k

"MartinW" <[email protected]> wrote in message
news:[email protected]...
> Hi Digital2K,
>
> Highlight all of your names in column A.
> Goto Data>Text to Columns.
> In the first page of the wizard select delimited then click next.
> In the second page of the wizard check space (make sure all other
> options are unchecked.) then click next.
> In the third page in destination put $B$1 and click finish.
>
> These directions are for Excel 2000, if you have a different version
> the process may be a little different but the basics should be the same.
>
> HTH
> Martin
>
>
>
>
>
>
> "Digital2k" <[email protected]> wrote in message
> news:[email protected]...
>> Thank you Martin,
>> but I'm not an expert. I'm not clear on what I'm supposed to do with
>> this.
>> The Full name is in column (A) I want the first name in column (B) and
>> the last name in column (C).
>> Where would I use Data>Text at?
>> Digital2k
>>
>> "MartinW" <[email protected]> wrote in message
>> news:[email protected]...
>>> Hi Digital2k,
>>>
>>> Data>Text to Columns will do that admirably.
>>>
>>> HTH
>>> Martin
>>>
>>
>>
>
>

[Michael Bednarek]

On Sun, 16 Jul 2006 08:48:34 -0400, "Digital2k" wrote in
microsoft.public.excel:

>Is it possible to divide first and last names that have a space between them
>is one cell and put copy them to two separate cells?

Define first and last name.

Any simple solution will not produce the required results for other than
the most simple cases. Consider: John Fitzgerald Kennedy, Jan de Beer,
Sir Peter Ustinov, Marshall Bruce Mathers III.

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

[Digital2k]

OK, What would be your solution is a case like your example?
Digital2k

"Michael Bednarek" <[email protected]> wrote in message
news:[email protected]...
> On Sun, 16 Jul 2006 08:48:34 -0400, "Digital2k" wrote in
> microsoft.public.excel:
>
>>Is it possible to divide first and last names that have a space between
>>them
>>is one cell and put copy them to two separate cells?
>
> Define first and last name.
>
> Any simple solution will not produce the required results for other than
> the most simple cases. Consider: John Fitzgerald Kennedy, Jan de Beer,
> Sir Peter Ustinov, Marshall Bruce Mathers III.
>
> --
> Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

[David McRitchie]

Michael is just giving an advisory notice that you may have to
tweak the results. With programming one has more control and
can write a bunch of exceptions and manually correct others. Something
made more difficult if relying on Worksheet Formulas and/or
starting over each time with a listing. Examples for three or
four names is a bit rough considering that the OP said they
start with first and last names meaning no titles and somebody
presumably removed extraneous initials would leave only
compound first names and compound last names as a problem.

The obvious answer would be that CHAR(160) were included
in compound names (including III and Jr, Sr), no titles are included,
and CHAR(160) is treated same as space for sorting. But it
also depends on who the list is intended for.

"Digital2k" <[email protected]> wrote
> OK, What would be your solution is a case like your example?

[Digital2k]

Thank You David!
Digital2k

"David McRitchie" <[email protected]> wrote in message
news:%[email protected]...
> Michael is just giving an advisory notice that you may have to
> tweak the results. With programming one has more control and
> can write a bunch of exceptions and manually correct others. Something
> made more difficult if relying on Worksheet Formulas and/or
> starting over each time with a listing. Examples for three or
> four names is a bit rough considering that the OP said they
> start with first and last names meaning no titles and somebody
> presumably removed extraneous initials would leave only
> compound first names and compound last names as a problem.
>
> The obvious answer would be that CHAR(160) were included
> in compound names (including III and Jr, Sr), no titles are included,
> and CHAR(160) is treated same as space for sorting. But it
> also depends on who the list is intended for.
>
> "Digital2k" <[email protected]> wrote
>> OK, What would be your solution is a case like your example?
>
>