ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   copy/paste words in cell can't be read on screen (https://www.excelbanter.com/excel-discussion-misc-queries/85842-copy-paste-words-cell-cant-read-screen.html)

MO

copy/paste words in cell can't be read on screen
 
I have been copying information from e-mails and pasting into cells within
excel. Although I have text wrap on, the text does not wrap. I paste a
great deal of information into cells. The only way I can get text to wrap is
to use Alt & enter which creates a hard return. Is there another workaound
so I don't have to continue doing this?
--
Thank you for your help
MO
Albany, NY

Dave O

copy/paste words in cell can't be read on screen
 
Have you tried formatting the cells to allow text wrapping _after_ the
paste from email? When you copy and paste from another application you
may be inadvertently bringing in formatting from that other application
that conflicts with or overrides existing formats in Excel. For
instance if you copy a section of text off a web page and paste it into
Excel you'll get a ton of unexpected formatting. Formatting after the
paste may resolve your problem.


John

copy/paste words in cell can't be read on screen
 
Try choosing Special Paste - unicode text or paste directly to the fx bar.

"MO" wrote:

I have been copying information from e-mails and pasting into cells within
excel. Although I have text wrap on, the text does not wrap. I paste a
great deal of information into cells. The only way I can get text to wrap is
to use Alt & enter which creates a hard return. Is there another workaound
so I don't have to continue doing this?
--
Thank you for your help
MO
Albany, NY



All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com