Paste 3 columns in Word - how do I get rid of all the spaces?

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

Guest

When I take 3 columns from an Excel spreadsheet, paste them into Word the last column (some cells are blank, others have text) there is multiple spaces in each cell. How do I eliminate those spaces? I need to then merge the cells and save the document as text only, but as it currently stands this sends my data everywhere due to all the spaces. I have tried to just use the replace function, but the number of spaces varies per cell and I have multiple data sets that require this conversion.

A little help Please?
 
Have you tried replacing double-space with single-space x times (until no
more found)?

HTH,
Andy

pragmaticEarl said:
When I take 3 columns from an Excel spreadsheet, paste them into Word the
Click to expand...
last column (some cells are blank, others have text) there is multiple
spaces in each cell. How do I eliminate those spaces? I need to then merge
the cells and save the document as text only, but as it currently stands
this sends my data everywhere due to all the spaces. I have tried to just
use the replace function, but the number of spaces varies per cell and I
have multiple data sets that require this conversion.
 
Yes, though I was hoping there was a way around doing the replace function over and over as I have to repeat this process 30 some times.
 
Sure, that can be pretty tedious. You could record it as a macro one time
(in either app) with a shortcut key combo & just use that (?)

Rgds,
Andy

PragmaticEarl said:
Yes, though I was hoping there was a way around doing the replace function
Click to expand...
over and over as I have to repeat this process 30 some times.
 
Maybe you could (in Excel) insert a column left of the 3rd and use the TRIM
function? Not sure how well this might work as the info on the spacing is a
little vague.

Rgds,
Andy

PragmaticEarl said:
Yes, though I was hoping there was a way around doing the replace function
Click to expand...
over and over as I have to repeat this process 30 some times.
 
Back
Top