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.
 

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

character limit 3
Valided alphanumeric value 3
character limit in hyperlink function 0
hash function for large strings 22
SUMDIVISION formula function - does it exist? 6
Using lookup function on multiple rows and columns 2
is 3rd character in a cell a space? 5
Format single character 4

Top