Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to trim a character from a cell ?
Hi, I have a macro that compares two numbers from when i scan a
quantity on a part number. And if the first cell is greater than the second cell, the first cell should highlight a color, which is working with no problems. But the problem is that everytime I scan a part number the amount always begins with a "Q" example:Q000003. And it will always give me the wrong results. The cell will still highlight even though the first cell is less than the second cell, because of the "Q". I know this because I've tried putting two numbers without the Q manually and I always get the right results. Basically, I don't know the syntax to use the trim method or mid method in vb6. I just need a method to remove the character "Q" but not the numbers. And would I put this syntax in my module where I have my macro? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
Trim cells to a character | Excel Worksheet Functions | |||
Trim down on cell references | New Users to Excel | |||
Trim all but the first 5 characters in cell | Excel Programming | |||
VBA Trim and Application.worksheetfunction.Trim | Excel Programming |