View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default eliminating extra spaces in Excel cells

Hi

You could use Find/Replace, finding 2 spaces and replacing with 1

Andy.

"Laura1" wrote in message
...
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!