Delete part of a text string
 

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

Delete part of a text string
 

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

Delete part of a text string
 

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

Delete part of a text string
 

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