Test For 1,024 Characters

[Lewis Clark]

Hello, Group!

I know that Excel will only display 1,024 characters in a cell. Is there an easy way to test all worksheets in a workbook to see if any cells exceed this limit?

Thank you very much in advance!
--

 

[Lewis Clark]

One more question: Is there a way to identify which cells, or at least which sheets, exceed the limit?

Thank you!

--

Hello, Group!

I know that Excel will only display 1,024 characters in a cell. Is there an easy way to test all worksheets in a workbook to see if any cells exceed this limit?

Thank you very much in advance!
--

 

[Beege]

Would you want to try conditional formatting (if LEN(A1)>1024, format
dfferently?

Beege

Hello, Group!

I know that Excel will only display 1,024 characters in a cell. Is there an
easy way to test all worksheets in a workbook to see if any cells exceed
this limit?

Thank you very much in advance!
--

 

[Dave Peterson]

And you can exceed that limit by adding alt-enters every 80 or 100 characters.

 

[Lewis Clark]

Conditional formatting might work - that's a great idea!

Some of the cells already have a conditional format, and I would probably want this to be the first condition to ensure it is evaluated. Is there an easy way to change the order of the conditional format tests (aside from deleting and reentering)?

Thank you!

--

Would you want to try conditional formatting (if LEN(A1)>1024, format
dfferently?

Beege

Hello, Group!

I know that Excel will only display 1,024 characters in a cell. Is there an
easy way to test all worksheets in a workbook to see if any cells exceed
this limit?

Thank you very much in advance!
--

 

[Lewis Clark]

I was not aware of this. Thanks for the lesson!

I think the conditional formatting will work better in my current application, but I have saved this idea in my file of Excel goodies for future use.

Lewis