Delete part of a text string

  • Thread starter Thread starter IanP
  • Start date Start date
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
 
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>
 
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
 
Back
Top