Using part of a number in another cell

**UBERMASS** · 11-17-2007, 05:03 AM

Hi Everyone,

hopefully an easy solution to this;

I want to use the last 3 digist of a referance number in another cell....for example;

I have the number 600003 in a cell and want to referance the last 3 digits in another cell...003, can this be done with a simple command.

Cheers,

Rich.

**davesexcel** · 11-17-2007, 05:39 AM

Originally Posted by UBERMASS

Hi Everyone,

hopefully an easy solution to this;

I want to use the last 3 digist of a referance number in another cell....for example;

I have the number in a cell and want to referance the last 3 digits in another cell...003, can this be done with a simple command.

Cheers,

Rich.

=RIGHT(A1,3)