Character limit

  • Thread starter Thread starter singkit
  • Start date Start date
S

singkit

Hello there!

Can you please help me how to determine if the value I
input in excel exceed to 10 character or 20 character.

Is there a formula or easier way to determine which
records exceed to limit of 10 character or 20 character.

Your help is greatly appreciated!
Thank you!
 
Alternatively, if you'd like to highlight those that go over 10, select the
cells (say D1:D10), go to format>conditional formatting> formula is
=LEN(D1)>10 then select format to be red, bolded, etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Limitations on Sumif Calculation 3
character limit 3
Valided alphanumeric value 3
text exceeds allowed number of characters per cell 1
hash function for large strings 22
Adding the total # of characters in multiple cells 3
Lower-Case Characters 2

Back
Top