What is the default text string size that can be entered into a cell and can I increase it?
J JBH Apr 19, 2005 #1 What is the default text string size that can be entered into a cell and can I increase it?
D Dave Peterson Apr 19, 2005 #2 The default??? The maximum in xl97+, is 32,767 characters. If you don't do anything special, you'll be able to see about 1000 characters. But if you add alt-enters to force new lines within the cell (every 80-100 characters), you'll be able to see lots more.
The default??? The maximum in xl97+, is 32,767 characters. If you don't do anything special, you'll be able to see about 1000 characters. But if you add alt-enters to force new lines within the cell (every 80-100 characters), you'll be able to see lots more.