View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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