View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Extracting after a "-"

This assumes there is only one "-" in your text string.

=RIGHT(A1,LEN(A1)-FIND("-",A1))

HTH,
Paul

"A.S." wrote in message
...
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?