Removing up to 3 last letters, excel
 

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

Removing up to 3 last letters, excel
 

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

=right(a1,3)


" wrote:

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