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