Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I eliminate spaces/characters from the beginning of a cell
I have a macro that has hit a snag. On one of the pages of the workbook, I
have a list of product codes. Some are copied over and sort fine. Others, the same codes, are copied with a leading space or a " ' " before the code. Is there an If then statement I can use that will remove any leading spaces or this symbol? It's messing up a sort that the entire macro depends on. Not all of the product codes have these spaces or characters which is why I need an if then statement to do nothing if they aren't there and to remove them if they are. Thanks in advance for any help you can offer. -- A Waller |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I eliminate 1 bar on the bar chart? | Charts and Charting in Excel | |||
how eliminate zeros in blank cells using paste link | Excel Worksheet Functions | |||
How do I eliminate zeros from my Excel database? | Excel Discussion (Misc queries) | |||
macro to eliminate spaces between words | Excel Discussion (Misc queries) | |||
eliminate white space in Excel file | Excel Discussion (Misc queries) |