fixed length string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

alekmil
 
Hi
use 'Data - Validation - Custom' and use the following
formula (for cell B1):
=LEN(B1)=7
 
Hi, it helped. Thanx
Where can I find generally on syntax that goes in that custom formula field?
alekmil
 
Back
Top