View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
excelent excelent is offline
external usenet poster
 
Posts: 695
Default Extracting after a "-"

=MID(A1;FIND("-";A1)+1;255)


"A.S." skrev:

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?