Pasting Word Tables

[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?

 

[Rafael Ortiz]

You can highlight the cells and select Format, Cells, Alignment, and
de-select Merge cells.

MRO

 

[Martha]

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?

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.

 

[Debra Holloway]

How can I do a search and replace in Excel so that a ";" is replaced with a
carriage return?

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

 

[Dave Peterson]

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.)

How can I do a search and replace in Excel so that a ";" is replaced with a
carriage return?