Hi,

Am Tue, 18 Nov 2014 20:02:21 -0800 (PST) schrieb GWC:

A1 contains one line
B1 contains one line
C1 contains one line
D1 contains one to many lines
E1 contains one line
F1 contains one to three lines
G1 contains one line
H1 contains one to many lines

how do you create the new line? If you do it with Alt+Enter you can
count char(10):
For 3 lines only:
Data Validation = Custom =
=LEN(F1)-LEN(SUBSTITUTE(F1,CHAR(10),))<=2


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional