assuming data is in A1
=LEFT(A1,LEN(A1)-3)
you could also use a Mid()
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"markx" wrote:

Hi guys,

Is there any formula in excel that will extract me all the text from a
string except three last caracters?
Thanks a lot in advance for your help on this,

Rgds,
Mark