Removing up to 3 last letters, excel

  • Thread starter Thread starter nsamsoon
  • Start date Start date
N

nsamsoon

Hi,

I am currently rtying to process a list and i only need the last 3
characters from the right only.
Example:

I have this:
C.IIDENNRIVT.V

and i only need it to be:
T.V
ot VT.V

Is there any way how to do this?

Thanks
 
If your string is in A1, you can use a cell with a formula:

=right(a1,3)
 
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

the Last occurance 3
Excel Convert word into numbers and back 4
Extracting all info in Cell except last 3 characters 2
The Last of Us - Part I (PC) 6
Windows 10 Activate windows now message 3
Calculating last 3 months 1
formulate email address based on last name & first letter of first 1
Formulas to display all 3 letter combinations in 8 letters 1

Back
Top