cutting text

[Guest]

Hello,

I know how to cut text from the left for a fixed width, but how can I do it
from the right? I have a column of data in which I need to cut the last 2
digits off of to do some analysis....example....

LV2345
2345

I'd like to cut the 45 off. I thought text to columns would work if I right
justified, but it doesn't. I'm wondering is there something I can do with
the "left" or "right" function? Thanks much

 

[Guest]

Hi

Try something like:
=MID(A1,1,LEN(A1)-2)

Andy.