I copied a paragraph from Word and used Paste Special to paste it to an Excel
document. I selected TEXT from the options in the Paste Special dialog box.
Now I can see only part of the text, but when I hit F2 to edit it shows all
of text. I have expanded my row to allow for the size of the paragraph.

The only formatting I have done is to wrap text and merged cells to allow
for the size of the test. I have also expanded my row to allow for the size
of the text.

Any thoughts as to why I see all the text when I hit F2, but only part of
the text when viewing it.