ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Trim characters (https://www.excelbanter.com/excel-programming/308010-trim-characters.html)

Ange[_3_]

Trim characters
 
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

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

"Ange" a écrit dans le message de
m...
Hello.

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

thank you





All times are GMT +1. The time now is 07:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com