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
|