Rows with cells of varying number of lines
 

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

Rows with cells of varying number of lines
 

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

Rows with cells of varying number of lines
 

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

Rows with cells of varying number of lines
 

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

Rows with cells of varying number of lines
 

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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Rows with cells of varying number of lines
 

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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional