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.

"Laura1" wrote:

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!