last 2 digits
 

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)

last 2 digits
 

On Mar 5, 10:01 am, rexmann wrote:
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)

last 2 digits
 

Hi Cortez

Thanks, worked perfect!

Cheers Rexmann

"Cortez" wrote:

On Mar 5, 10:01 am, rexmann wrote:
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)