Rows with cells of varying number of lines

[GWC]

How do I set-up my spreadsheet so:

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


Note: The subsequent rows have the same situation as row 1

 

[Claus Busch]

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.

 

[GWC]

If I use ALT+ENTER to create multiple lines in a cell will the rest of the cells in that row become taller too?

 

[GWC]

How can I combine the contents in cells C3, D3, E3 and F3 into one cell?

 

[Claus Busch]

Hi,

Am Wed, 19 Nov 2014 06:17:44 -0800 (PST) schrieb GWC:

If I use ALT+ENTER to create multiple lines in a cell will the rest of the cells in that row become taller too?

yes, a row has the same height over all the columns. You can't create
cells with different height in one row.


Regards
Claus B.

 

[Claus Busch]

Hi,

Am Wed, 19 Nov 2014 06:34:39 -0800 (PST) schrieb GWC:

How can I combine the contents in cells C3, D3, E3 and F3 into one cell?

if you want wrap text format the cell and then:
=C3&CHAR(10)&D3&CHAR(10)&E3&CHAR(10)&F3
Else replace char(10) with " "


Regards
Claus B.