Extracting firstname and secondname with functions

[Mervyn Thomas]

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

 

[Jarek Kujawa]

A1=John Brown

will be separated:

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

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

HTH

 

[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