formatting large amount of text in a cell

TinaP

TinaP

Well-known Member
Joined
Jan 26, 2005
Messages
528
I'm using Excel to track audit findings and am having trouble with a few cells. I'm using Excel rather than Word so that I can filter the findings. There is a large amount of text in the cells (1900+ characters) and it uses 18 lines of the formula bar. I've started a new line in the cell by using Alt+Enter several times as well.

Here's my problem: I have wrap text turned on but only the first 12 lines wrap. I'm using Excel 2003, but when the same file is viewed in Excel 2007, it displays perfectly. Any ideas?
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
Ideas in order of priority:

1) Use Word. Learn how Word can provide filtering capability, too. Word is inherently designed to manage,display,manipulate text in ways Excel can only dream about.

2) Use Excel 2007 since it has greater display capability

3) Expand the columns in Excel 2003 so you need fewer rows.
 
Upvote 0
Well, option 2 (Use Excel 2007) isn't an option since I'm limited to what my company decides to give me and I have to be able to share the document with others who may have different versions of Excel. And expanding the column width doesn't change anything.

Unless anyone else has an idea, I guess I'll have to use tables in Word.

I this just a limitation of earlier versions of Excel?
 
Upvote 0
Hi Tina
Looking at the cell limitations in Excel help comes up with:
Code: 
Length of cell contents (text) 32,767 characters. 
Only 1,024 display in a cell; all 32,767 display in the formula bar.

So it looks like you may be exceeding the visible limit.

Regards
Michael M
 
Upvote 0
Michael,

Upon further investigation, the problem does begin arolund the 1024 character mark.

Thanks for your help.
 
Upvote 0
Sounds like the problem then !
If you input "specifications" into Excel help, it will provide all the worksheet, cell, etc limitations.

Regards
Michael M
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
Large Numbers Display vs Storage
Replies
1
Views
61
Alex Blakenburg
A
B
  • Solved
SEARCHING ANOTHER WORKBOOK FOR CURRENT ACTIVE TEXT OFFSET AND RETURNING TEXT FROM 3 CELLS OFFSET FROM FOUND TEXT
2
Replies
11
Views
123
BAKELOVEMORE
B
G
  • Question
Converting a ASCII text file with strange delimiters.
2
Replies
14
Views
562
felixstraube
F
R
  • Solved
Using conditional formatting to highlight the row of a cell containing specific text.
Replies
4
Views
299
etaf
etaf
SaraWitch
  • Solved
Join text and return dates where there is one but ignore if empty cells
2
Replies
12
Views
551
SaraWitch
SaraWitch

Forum statistics

Threads
1,214,975
Messages
6,122,538
Members
449,088
Latest member
RandomExceller01

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top