View Single Post
  #1   Report Post  
Steve
 
Posts: n/a
Default Pasting Word table cell with paragraph markers into single Excel c

I have a Microsoft Word document that contains a table, each cell of which
may contain paragraph markers. I need to copy and paste this table into
Excel. However, whenever a cell from the Word table contains paragraph
markers, rather than pasting the contents of the entire cell into a single
cell in Excel, the paragraph markers are treated as delimiters, and the data
is pasted into multiple Excel cells. If the cell from the table in Word
contains one paragraph marker, then when I paste that cell to Excel, it
pastes it into two cells. If it contains two paragraph markers, then it
pastes into three cells, and so on. I need to be able to paste this Word
table into Excel so that the paragraph markers are treated like "alt-Return"
- that is, a hard return within a single cell in Excel, so each cell from the
table in Word gets pasted into one cell in Excel, regardless of how many
paragraph markers are contained in each cell. Any ideas?