fixed length string

A

alekm

Hi,
how can I force user to enter a string of fixed length in a cell (eg. 7
characters)?
Thanx

alekmil
 
F

Frank Kabel

Hi
use 'Data - Validation - Custom' and use the following
formula (for cell B1):
=LEN(B1)=7
 
A

alekm

Hi, it helped. Thanx
Where can I find generally on syntax that goes in that custom formula field?
alekmil
 
Top