try resetting the newsgroup. it should show up.

--


Gary


"Dean" wrote in message
...
For some reason, when I checked in today, I did not see my post yesterday.
In fact, I still don't! I assume it is some quirk of Outlook Express.
Can you tell me the URL so I can view these answers directly, although the
two answers to my 2nd post are both excellent enough.

Sorry,
Dean

"Gary Keramidas" wrote in message
...
why not look at all the replies to your original post yesterday? no need
to post again

you could also do this:
select the entire column
click data and then text to columns
choose delimited
click next
put a check next to space under delimiters
click next and then finish

it will put the dates in the next column to the right. if you have data
there now, just insert a column to the right of the original "date" field



--


Gary


"Dean" wrote in message
...
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