Thread: Delete part of a text string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IanP IanP is offline
external usenet poster
  
Posts: 3
Default 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
Reply With QuoteReply With Quote