View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do I delete an extra space in every cell in a column?

Maybe just select that column
edit|replace
what: (space character)
with: (leave blank)
replace all



iamjbunni wrote:

My report generates dates with a space in front of every cell in that column.
I would like to delete that extra space in every cell all at once. Is there
a way I can do that?


--

Dave Peterson