Extracting all info in Cell except last 3 characters
 

I am trying to write a formula to give me the value of a cell except for the
last 3 characters. The amount of characters in the cell vary, but the last 3
that i want excluded remain constant. Any suggestions?

Thanks
--
Eric

Extracting all info in Cell except last 3 characters
 

Try it this way:

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

Hope this helps.

Pete

"Eric D" wrote in message
...
I am trying to write a formula to give me the value of a cell except for
the
last 3 characters. The amount of characters in the cell vary, but the
last 3
that i want excluded remain constant. Any suggestions?

Thanks
--
Eric