| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing blank characters from left of field
I am trying to import data where there is sometimes a blank in the cell
before the data - space bar. I need to get the VBA code to do something like "If left character is blank then delete left character and move ramining chaacters to the left" Tried a few different ways in VBA, but none seem to do the trick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
| removing everything from the left after 10 digits | Excel Worksheet Functions | |||
| Removing blank characters ? | Excel Discussion (Misc queries) | |||
| Removing characters from datetime field | Excel Discussion (Misc queries) | |||
| Copying and pasting a worksheet to a blank and removing blank rows | Excel Programming | |||
Threaded Mode
