View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
childothe1980s childothe1980s is offline
external usenet poster
 
Posts: 23
Default stripping out the first space

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