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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Maybe just select that column
edit|replace
what: (space character)
with: (leave blank)
replace all
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

removing extra spaces 2
Removing a keystroke 5
Displaying zeros in cells 2
merging spreadsheets/one has extra space in each cell 2
Numbers followed by space 4
eliminating extra spaces in Excel cells 4
space in cell 3
Extra spaces in a copy/paste from Excel into Word as a link with HTML formatting 0

Back
Top