Thread: Trim characters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
MD MD is offline
external usenet poster
 
Posts: 26
Default 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