Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have inherited a file with a column of dates. However, each data
apparently has a blank space in front of it, so it is not recognized as a real date. Hence I cannot perform algebraic manipulations on them as is. I need to be able to go to each cell (thousands of them) in these columns and take out this space on the left. Can someone tell me what the macro should be to, say, start in cell C8 and edit it and take out the leftmost character (which is a blank), and then move on to the next row down in that column. Since some of the rows might be empty, it would be better if we could just skip those, but it is not necessary. In case it helps, I believe that all dates are in xx/yy/zz format (with one spacebar in front). Thanks! Dean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
Macro command | Excel Discussion (Misc queries) | |||
How to run a macro with the IF command | Excel Worksheet Functions | |||
macro command | Excel Worksheet Functions | |||
macro command | Excel Discussion (Misc queries) |