Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
MO
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
John
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 01:36 AM
Active cell moves off the screen John W. Excel Discussion (Misc queries) 1 November 15th 05 11:12 PM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM
Using Jet to read excel file returns blank for last cell - sometim Ron Excel Discussion (Misc queries) 1 December 9th 04 08:21 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"