Thread: Extracting after a "-"
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default Extracting after a "-"
I want to take everything to the right of a "-", but the formula I am using
cuts part of it and doesn't give me everything. Is there a formula that
gives
me everything to the right regardless of length of characters in the cell?

Assuming your text is in A1, this seems to work...

=MID(A1,1+FIND("-",A1),LEN(A1)-FIND("-",A1))

Rick

Reply With QuoteReply With Quote