I have a situation where text is being copied in Word and then pasted into an
Excel workbook. I have merged the cells and selected wrap text for the
particular cells being used for this. However, when the text is pasted into
the cell, sometimes the text doesn't wrap and parts of words get cut off or
it appears that the text wrap stops at a certain point and runs off to the
right. Is there something I'm doing wrong or is there a fix to this problem.
I know that merged cells do not autofit and dragging the cell to increase
the row height doesn't seem to fix the problem with the text which runs off
to the right. Any help would be greatly appreciated.