Originally Posted by
md95065
Thanks for the suggestion, but that is exactly what I already did.
Suppose that I have a Word table that has three columns and one of the rows looks like this:
01/01/2007 aaaaaaaaaaaaaaaaaaa $100.00
bbbbbbbbbbbbbbbbbbb
ccccccccccccccccccc
Note that this is a *single* row, but the middle cell contains 3 lines of text with line-breaks.
If I copy and paste this row into Excel, it takes up *three* rows and the text is split up into *three* cells, one line per cell. Since this is all related information I want everything to be on the same row, with the text in a single cell.
Unfortunately the only way that I have been able to make this work is to first edit the Word table to remove all of the line breaks from the text, copy and paste into Excel and then put all of the line breaks back in by hand.
Michael
PS I tried this with both Office 2003 and 2007 with exactly the same results.
Hi,
Just a thought, if that works for you, then you could replace the line breaks with (say) #$# and then in Excel replace #$# with the line break, this could be as a shortcut triggered macro.
The required line would be
Cells.Replace What:="#$#", Replacement:=Chr(10), LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
etc.
---
Bookmarks