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

try:

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

"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?