Extracting firstname and secondname with functions

M

Mervyn Thomas

Does anyone have functions which will extract "firstname" and "secondname"
into seperate cells from a cell containing "firstname secondname" ?
 
J

Jarek Kujawa

A1=John Brown

will be separated:

to John:
=LEFT(A1,FIND(" ",A1)

and Brown:
=RIGHT(A1,LEN(A1)-FIND(" ",A1))

HTH
 
A

Ashish Mathur

Hi,

You may also use Data > Text to columns. Select space as the delimited
(incluck the default Tab setting in the delimiter)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Top