Extracting after a "-"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=RIGHT(A1,LEN(A1)-FIND("-",A1))

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

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

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

HTH,
Paul
 
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?
Click to expand...

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

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

Rick
 
Back
Top