I need a formula

R

RBD

I need a formula that would allow me to copy one cell to another as
well as remove the first three characters.

example

cel a - 12321232 would copy to cell be as - 21232

If anyone could help me that would be soo awesome
 
M

MartinW

Hi,

Try one these
=RIGHT(A1,5)

If the lenght of your data is fluctuating then
=RIGHT(A1,LEN(A1)-3)

If you need them to return a number instead of text
then tack *1 on the end of them.

HTH
Martin
 
Top