Counting Using LEN

[rbobcat1]

Using LEN you can count characters in a cell.


if you have a range of cells that must have 12 characters always in each cell, how can you use the LEN command with a conditional format if less than 12 characters exist in a cell?

 

[Hui]

Rbobcat1


Good tip


You can also use Len in Data Validation to force the length of a cell's values

 

[Faseeh]

Hi rbobcat1,


Continuing with Hui's suggestion, try this in cell A1 in Data Validation > Custom:


=LEN(A1)=12


You can can't enter any thing short/larger then 12 characters.


Faseeh

 

[Luke M]

To answer the question, the CF formula would be:

=LEN(A2)<12