Trim characters

Ange · Aug 25, 2004

Hello.

Does anyone know how to take the last six characters from any given
cell? I need a formula to do this.

thank you

MD · Aug 25, 2004

Say you have 123456789 in cell a1
in cell a2 type =right(a1;6)
result: 456789