cutting text

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

Hi

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

Andy.

"Aaron" <[email protected]> wrote in message
news:[email protected]...
> 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