Delete part of a text string

I

IanP

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
 
T

T. Valko

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>
 
F

Francis

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
 
Top