last 2 digits

[Guest]

Hi all

I have a 12 digit number in a cell and I want to extract just the last 2
digits and display in a column next to it, and then replicate down the list.
Is this possible?

Equally, a few cells have 10 rather than 12 digits and I would like it to
work for them (although I can live without this as it is only a handful and I
know where they are)

Any help greatly appreciated

Kind regards

Rexmann (using excel 2002)

 

[Cortez]

Hi all

I have a 12 digit number in a cell and I want to extract just the last 2
digits and display in a column next to it, and then replicate down the list.
Is this possible?

Equally, a few cells have 10 rather than 12 digits and I would like it to
work for them (although I can live without this as it is only a handful and I
know where they are)

Any help greatly appreciated

Kind regards

Rexmann (using excel 2002)

=right(Ref1,2)

 

[Guest]

Hi Cortez

Thanks, worked perfect!

Cheers Rexmann