How to remove characters in a cell that precede a specific hyphen
If you always want to keep the characters after the last (no matter how many)
hyphen...
And you don't have to use a formula, you could use:
Select the range to fix
edit|replace
what: *- (asterisk, hyphen)
with: (leave blank)
replace all
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?
--
Dave Peterson
|