How do I delete an extra space in every cell in a column?

I

iamjbunni

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?
 
D

Dave Peterson

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

jbach11

Use the trim function, reference the cell that you want trim and copy
the formula down. Once you have the new data (trimmed) just copy and
post over the data.
 
Top