Sorry, this should do it for you.........

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

Vaya con Dios,
Chuck, CABGx3



"luvthavodka" wrote:

Thanks for this, however it is returning -43GF, rather than 43GF.

How can I expand on this formula to also remove the "-"?

Many thanks

"CLR" wrote:

With your data in column A, put this in B1 ad copy down........

=MID(A1,FIND("-",A1,1),99)

Vaya con Dios,
Chuck, CABGx3



"luvthavodka" wrote:

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.