Have First Name(Space)Midle Name in a cell - only need First Name.

Have been trying LEFT(A1,LEN(A1)-SEARCH((" ",A1)) but the new cell only
shows the first five characters of the first name.

Any suggestions

Ian

Try this as long as the first name is one word:

=LEFT(A1,FIND(" ",A1)-1)

If the first name is more than one word you're on your own! <g

--
Biff
Microsoft Excel MVP


"IanP" wrote in message
...
Have First Name(Space)Midle Name in a cell - only need First Name.

Have been trying LEFT(A1,LEN(A1)-SEARCH((" ",A1)) but the new cell only
shows the first five characters of the first name.

Any suggestions

Ian

try this to return the first name

=LEFT(A1,FIND(" ",A1)-1)
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"IanP" wrote:

Have First Name(Space)Midle Name in a cell - only need First Name.

Have been trying LEFT(A1,LEN(A1)-SEARCH((" ",A1)) but the new cell only
shows the first five characters of the first name.

Any suggestions

Ian

Hi,

Youmay also use Data Text to columns. Please use the delimiter as space.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"IanP" wrote in message
...
Have First Name(Space)Midle Name in a cell - only need First Name.

Have been trying LEFT(A1,LEN(A1)-SEARCH((" ",A1)) but the new cell only
shows the first five characters of the first name.

Any suggestions

Ian