Dividing first & last names?

D

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
 
D

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
 
D

daddylonglegs

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

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

Alternatively, using formulas, in B1

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

and in C1

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

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
 
B

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)
 
D

Digital2k

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

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.
 
D

Digital2k

Thank You David!
Digital2k

David McRitchie said:
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.
Click to expand...
 
Top