Try this:

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


--
Biff
Microsoft Excel MVP


"brantty" wrote in message
...
And one more example that has a zero.

ABC-07901-07901

I need the zero to stay with the number, thus the result to be: 07901.

thanks for your help

"FSt1" wrote:

hi,
you said the number of characters vary. could you supply more examples of
the data?

Regards
FSt1

"brantty" wrote:

I have a column of cells that have excess data that needs removed. The
#of
characters vary. I'm needing a formula to delete all the characters
that
precede the 2nd hyphen as well as delete the 2nd hyphen.

Ex. [ABC-12345-12345]

I need the cell to read [12345]

Can anyone provide a formula that can remove this data?