Removing up to 3 last letters, excel

[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

 

[Dave Peterson]

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

=right(a1,3)