I need a formula

  • Thread starter Thread starter RBD
  • Start date Start date
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
 
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
 
Back
Top