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

cutting text
 

Hi

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

Andy.

"Aaron" wrote in message
...
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