| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pasteing large amount of text to Excel merged cell
My users need to cut and paste from websites and Word docs to an Excel sheet.
I have informed them about the 1024 char limit and the manual ALT+Enter method of "revealing" the hidden text. I'm hearing soooo many "that's too time consuming/difficult" complaints that I must automate the text to fit. this documaent has to be printed and forwarded for approval so we have to "see" everything. Some pastes even exceed the 409.5 Rowheight limit. Could VBA code identify lines that exceed the 127 char width of my merged cell and add a Char(10) or something similar to the ALT+Enter? Can the Font size be manipulated in code to fit in the merged cells? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trying to automatic fit large amount of text in cell | Excel Discussion (Misc queries) | |||
| How do I get the a large amount of text to show in merged cell? | Excel Discussion (Misc queries) | |||
| how do I import a large amount of text into one cell? | Excel Discussion (Misc queries) | |||
| How do I paste a large amount of text into a cell ? | Excel Discussion (Misc queries) | |||
| Fit large amount of text in 1 cell | Excel Discussion (Misc queries) | |||
Threaded Mode
