G
Guest
I have a clomun of cells with various codes in e.g:
Column A
42NAFF16-43
927PLY833-16FF
16ARBY1-1
etc..
The only common factor in all these references is the dash symbol. I am
looking to return in another column just the figures after the dash e.g:
Column B
43
16FF
1
I'm stuck as to what formula to use as I'm only used to chopping off a fixed
number of digits! Any help is greatly appreciated.
Column A
42NAFF16-43
927PLY833-16FF
16ARBY1-1
etc..
The only common factor in all these references is the dash symbol. I am
looking to return in another column just the figures after the dash e.g:
Column B
43
16FF
1
I'm stuck as to what formula to use as I'm only used to chopping off a fixed
number of digits! Any help is greatly appreciated.