How to remove characters in a cell that precede a specific hyp
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?
|