Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
Finding Specific Text in a Text String | Excel Worksheet Functions | |||
SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |