cutting text

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top