Thread: i need help creating a function that will extract words from a string of text
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
  
Posts: 733
Default i need help creating a function that will extract words from a string of text
Harlan Grove wrote...
....
=REPLACE(LEFT(A1,FIND("|",A1,FIND("|",A1)+1)-1),1,FIND("|",A1),"")

Or shorter but with hardcoded #s,

=MID(LEFT(A1,FIND("|",A1,FIND("|",A1)+1)-1),FIND("|",A1)+1,1024)


Reply With QuoteReply With Quote