Once you have formatted the cell to wrap, the trick is to paste the
information into the formula bar instead of the cell.
--
Gary's Student


"psipg" wrote:

Hi All,

I am creating a table that will keep track of correspondance with clients.
The table is created in excel. Sometimes this correspondence comes in the
form of an email. I can manage to get the text to wrap after it has already
been pasted into the cell, but is there a way I can format the cell so that
is automatically text wraps when I paste in the email? I have tried
highlighting the cells and selecting text wrap on the format menu, but it
still seems to copy the email on one line.

Thanks,
psipg