text wrapping when text is pasted in excel
 

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

text wrapping when text is pasted in excel
 

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

text wrapping when text is pasted in excel
 

Thanks Gary's Student - that helped a lot!! :)

"Gary''s Student" wrote:

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