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)
|