Ask Experts Questions for FREE Help !
Ask
    kbettimac's Avatar
    kbettimac Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jan 16, 2009, 10:34 PM
    Wrapping large blocks of text in Excel 2003
    I've read through previous submissions and unfortunately none of the suggestions have worked for me. I'm working with fairly large blocks of text (1500+ characters) and wondered if anyone had found a workaround. Autoformat doesn't solve the issue, at least not in Excel 2003. Thanks.
    KISS's Avatar
    KISS Posts: 12,510, Reputation: 839
    Uber Member
    		  
    #2

    Jan 16, 2009, 10:41 PM

    If you get an ALT+Enter in there and delete it, it breaks properly. At the end it gives an extra line.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #3

    Jan 17, 2009, 09:57 AM

    You'll have to manually insert ALT-ENTER breaks somewhere between 80-100 characters per line to get it to display properly. Further, this page lists Excel's limitations in the Worksheet and workbook specifications section:
    http://office.microsoft.com/en-us/ex...CH062527721033

    It appears on 1,024 characters are going to display, though the call can manipulate 32,767 characters in the cell.

    The real workaround is not use Excel to manipulate text this way.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel 15 digit issue, tried converting to text, text to column feature negates fix [ 6 Answers ]

I have the following numbers that exceed 15 characters that needs to be split into its own columns. Down the road, there would be thousands of such rows of data with the first couple set of unique numbers. 890432453253208820,5004500558,05CC,1,0,0,0,0,0,0, 0000,5.0000,2007-01-11...

EXCEL - Wrap Text not working! [ 14 Answers ]

Hi I have a spreadsheet with one column having quite a bit of data in it. I have tried to 'wrap text' as well as 'auto-fit' within the row to no avail. Some of the information is still not visible no matter what I do. I have exhausted all possible options including excel help online and...

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.

Wrap Text in Excel 2003 [ 5 Answers ]

Am setting up a table for my DVD collection, so far, so good. Under the Notes column where I put in information regarding the movie, I've been going to Format, Cells, Alignment and clicking Wrap Text to get how I want it. Is there a way where the text would wrap without me doing that for every...

Text to large [ 3 Answers ]

Playing with my computer I increased the size of the text very large too large for my E-mail to fit along with everything else Nothing will fit correctly on pages How can I correct this??

View more questions Search