Excel 2007 – Separating names formula

Topic

New Reply

I have don Adams in cell A3. I need a formula in cell B3 that will look in cell A3 and show me only Don. I need a formula in cell C3 that will look in cell A3 and show me only Adams.

Thanks in advance.

Reply | Quote

Replies

In B3
=LEFT(A3,FIND(” “,A3)-1)

In C3:
=RIGHT(A3,LEN(A3)-FIND(” “,A3))

This presumes you will always have things of the form:
First name then 1 space then the last name…

Steve

Reply | Quote

I have don Adams in cell A3. I need a formula in cell B3 show me Don. and cell C3 show me Adams.

Another option :

B3 =MID(A3,1,FIND(” “,A3)-1)

C3 =MID(A3,FIND(” “,A3)+1,99)

Or

B3 =REPLACE(A3,FIND(” “,A3),99,””)

C3 =REPLACE(A3,1,FIND(” “,A3),””)

Regards
Bosco

Reply | Quote