Why not just do a find and replace on the blank. When the space is replaced
Excel should do an implicit conversion of the value to a date? It is a pile
easier than the code...
--
HTH...

Jim Thomlinson


"Dean" wrote:

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