How to remove characters in a cell that precede a specific hyp
Might help u
If A1 = ABA-12345M-12345M
IN B1 =MID(A1,SEARCH("-",A1,SEARCH("-",A1,SEARCH("-",A1)+1))+1,99)
On Apr 4, 7:10*am, brantty wrote:
Here's a few mo
Here's a few more examples
ABA-12345M-12345M
ABA-C12345-C12345
ABC-18L123-18L123
ABC-Q456789JJ-Q456789JJ
"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?- Hide quoted text -
- Show quoted text -
|