Pasting Word Tables

  • Thread starter Thread starter Debra Holloway
  • Start date Start date
D

Debra Holloway

I am trying to paste some word tables into an Excel spreadsheet. Some of
the cells show as merged cells (spanning several rows) once they are pasted
into Excel. I want them to come across as single cells. What do I need to
do?
 
You can highlight the cells and select Format, Cells, Alignment, and
de-select Merge cells.

MRO
 
Debra Holloway said:
I am trying to paste some word tables into an Excel spreadsheet. Some of
the cells show as merged cells (spanning several rows) once they are pasted
into Excel. I want them to come across as single cells. What do I need to
do?
Click to expand...

Make sure the table in Word doesn't contain any paragraph marks in any
cells. If this is unavoidable, paste without formatting into Excel.
(Right click, Paste Special, choose either 'Unicode Text' or 'Text'.)

Also, it should be obvious, but make sure the Word table doesn't have
any unwanted merged cells. :)
 
How can I do a search and replace in Excel so that a ";" is replaced with a
carriage return?

Debra Holloway said:
Thanks. I had replaced the paragraph marks with manual line breaks - so the
cells were still pasting as merged. I replaced them with ";" and it worked
fine :)


need
Click to expand...
 
Select your range first (so you don't change any real semi-colons.

Then Edit|Replace
find what: ; (semi-colon)
replace with: alt-0010
(hold the altkey while type 0010 from the number keypad. It may look like
nothing happened, but click on the replace all and see if you did it ok.)



Debra said:
How can I do a search and replace in Excel so that a ";" is replaced with a
carriage return?
Click to expand...
 
Back
Top