Exact all text except last 2 characters

Hi,

I need help determining how to extract all the characters in a column except for the last 2 characters. I have attached an example. I would like to extract all the characters in column D into Column E except for the last two characters. The problem I am having is that the text that is in column D is different lengths. Any help would be appreciated. Thanks


CK

Hi ClikClak,

Use below formula:-

Formula:

Please Login or Register  to view this content.

See attached:- example problem.xlsx


Regards,
DILIPandey

<click on below 'star' if this helps>

You are welcome ..

Cheeers


Regards,
DILIPandey

<click on below 'star' if this helps>

Also, request you to mark this thread as [SOLVED].... thanks

and start separate thread for other question...

Regards,
DILIPandey

<click on below 'star' if this helps>