Extracting firstname and secondname with functions
 

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

Extracting firstname and secondname with functions
 

A1=John Brown

will be separated:

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

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

HTH


On 27 Mar, 18:38, "Mervyn Thomas" wrote:
Does anyone have functions which will extract "firstname" and "secondname"
into seperate cells from a cell containing "firstname secondname" ?

Extracting firstname and secondname with functions
 

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

"Mervyn Thomas" wrote in message
...
Does anyone have functions which will extract "firstname" and "secondname"
into seperate cells from a cell containing "firstname secondname" ?