extact text string from specific cell except three last characters
 

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

extact text string from specific cell except three last characters
 

Try this:

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

Hope this helps.

Pete

On Oct 23, 2:08 pm, "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

extact text string from specific cell except three last characters
 

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

extact text string from specific cell except three last characters
 

Thanks,
It works perfectly!

"John Bundy" (remove) wrote in message
...
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