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
...
Someone has sent me a huge spreadsheet with a column full of dates. Well,
not really, each date has a blank space in front of it, so I guess even
though it may say 02/23/2004, it is really just a label.

I need to have the dates so I can subtract them from one another, etc.

I would like to have a macro that can go down the column (say start in
cell c5 and go down as far as c4000 and remove the space in front of each
entry. Can someone tell me how to write that macro?

Thanks much!
Dean