Extracting firstname and secondname with functions

  • Thread starter Thread starter Mervyn Thomas
  • Start date Start date
M

Mervyn Thomas

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

will be separated:

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

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

HTH
 
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
 
Back
Top