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.
 
Back
Top