View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mark Lincoln Mark Lincoln is offline
external usenet poster
 
Posts: 227
Default Extracting after a "-"

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

This will extract the needed text from A1. Adjust to fit your needs.

Mark Lincoln

On Jun 12, 4:13 pm, A.S. wrote:
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?