Insert a column to the right of the problem column
use this formula:
=RIGHT(A1,LEN(A1)-1)
Drag down the length of the column
Copy the column
Paste Special... Values Only over the problem column

HTH

Die_Another_Day
childothe1980s wrote:
Hello:

I have a column of date fields. For whatever reason, there is a space in
front of each date in each cell in this column.

I need to strip out this space, so that I can format this column properly.
How do I do this?

If I cannot find a formula, then I will have to go through all 800 cells and
manually take the space out of each cell.

Thanks!

childofthe1980s