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
|