eliminating extra spaces in Excel cells

G

Guest

Hello everyone, I just ran a report in Access, copied and pasted the data in
to Excel. Now, though, there are extra spaces after the data in each cell.
How do I get rid of these extra spaces? I need to do a mail merge and it's
not merging correctly because of all of these extra spaces.

So my merge looks like this: Joe Smith

Any help is appreciated!
 
G

Guest

Use the TRIM function. Create a blank column after column that has the extra
spaces (e.g. if it is Column A, create Column B), in cell B1 type =TRIM(A1),
then copy down. Now copy Column B and use Edit > Paste Special, Values to
paste over the data in Column B and eliminate the formula. You blank spaces
will be gone.
 

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
Trailing Spaces in Merged Cells 1
Extra Spaces with copied data 5
Eliminating extra spaces in mail merge with Excel/Publisher 2
Extra spaces in a copy/paste from Excel into Word as a link with HTML formatting 0
Macro to remove trailing spaces in cells 2
Nonbreaking Spaces in Excel @!*$# 3
Exporting to "prn" adding extra spaces with Excel 2003 2

Top