ExcelBanter - Text String in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Text String in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/22602-text-string-excel.html)

JBH

Text String in Excel

What is the default text string size that can be entered into a cell and can
I increase it?

Dave Peterson

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.

JBH wrote:

What is the default text string size that can be entered into a cell and can
I increase it?

--

Dave Peterson

All times are GMT +1. The time now is 07:03 AM.