Can anyone help??

I have a name in cell A1, but I want to split the name into cells A2 and A3.
eg, A1 = Simon Thomas, I want B1 to = Simon & C1 to = Thomas
Does anyone know the formula for this??

Thank you in advance

Assuming that names contain first and last name only...

First name:

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

Last name:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

Hope this helps!

In article ,
"Simon" wrote:

Can anyone help??

I have a name in cell A1, but I want to split the name into cells A2 and A3.
eg, A1 = Simon Thomas, I want B1 to = Simon & C1 to = Thomas
Does anyone know the formula for this??

Thank you in advance

To get the first portion

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

to get the last portion

=RIGHT(A1,LEN(A1)-SEARCH(" ",A1,1))

This will not address cases where you have names such as

Saint James Susan or Billy Bob Thornton

but will work for standard 2 name entries



"Simon" wrote:

Can anyone help??

I have a name in cell A1, but I want to split the name into cells A2 and A3.
eg, A1 = Simon Thomas, I want B1 to = Simon & C1 to = Thomas
Does anyone know the formula for this??

Thank you in advance

You could just copy column A to B, and then use DataText To Columns with a
space delimiter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Simon" wrote in message
...
Can anyone help??

I have a name in cell A1, but I want to split the name into cells A2 and
A3.
eg, A1 = Simon Thomas, I want B1 to = Simon & C1 to = Thomas
Does anyone know the formula for this??

Thank you in advance