Thread: Extracting Data From The Right of a Cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default Extracting Data From The Right of a Cell
The data I want to extract is the data "to the left" of
the "second dash from the right".

Give this formula a try...

=LEFT(A1,FIND("?",SUBSTITUTE(A1,"-","?",LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))-1))-1)

Rick Rothstein (MVP - Excel)

Reply With QuoteReply With Quote