Character limit

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!
 
D

Dave R.

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