Trim characters

  • Thread starter Thread starter Ange
  • Start date Start date
A

Ange

Hello.

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

thank you
 
Say you have 123456789 in cell a1
in cell a2 type =right(a1;6)
result: 456789
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting a Part of a Formula as Text 5
Formula error 4
triming the first 10 characters in a cell.. 2
Help needed 0
Removing with formula 1
Manipulating Strings in a Macro 2
Test if Last Character in Column of Cells is Alpha Character 6
No characters data in Hyperlink cell 3

Back
Top