extact text string from specific cell except three last characters

[markx]

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

 

[Pete_UK]

Try this:

=LEFT(A1,LEN(A1)-3)

Hope this helps.

Pete

 

[Guest]

assuming data is in A1
=LEFT(A1,LEN(A1)-3)
you could also use a Mid()

 

[markx]

Thanks,
It works perfectly!

assuming data is in A1
=LEFT(A1,LEN(A1)-3)
you could also use a Mid()