Possible to add a Line break in a formula ?
 

I have 4 cells of postal address data which I want to combine and include
line breaks.

I know that to combine them in a continuous sequence I can use

=B4&", "&C4&", "&D4&", "&E4

But I want to insert a line break instead of a comma so that the result
appears as follows

B4
C4
D4
E4

instead of B4, C4, D4, E4 which the previous formula would give me.

Anyone any ideas?

Possible to add a Line break in a formula ?
 

=b4 & char(10) & c4 & char(10) & d4 & char(10) & e4

Then:
Format Cells... Alignment check wrap on
--
Gary''s Student - gsnu200768


"Ricardo the Numpty" wrote:

I have 4 cells of postal address data which I want to combine and include
line breaks.

I know that to combine them in a continuous sequence I can use

=B4&", "&C4&", "&D4&", "&E4

But I want to insert a line break instead of a comma so that the result
appears as follows

B4
C4
D4
E4

instead of B4, C4, D4, E4 which the previous formula would give me.

Anyone any ideas?

Possible to add a Line break in a formula ?
 

Have a big gold star :)

Many thanks.

"Gary''s Student" wrote:

=b4 & char(10) & c4 & char(10) & d4 & char(10) & e4

Then:
Format Cells... Alignment check wrap on
--
Gary''s Student - gsnu200768


"Ricardo the Numpty" wrote:

I have 4 cells of postal address data which I want to combine and include
line breaks.

I know that to combine them in a continuous sequence I can use

=B4&", "&C4&", "&D4&", "&E4

But I want to insert a line break instead of a comma so that the result
appears as follows

B4
C4
D4
E4

instead of B4, C4, D4, E4 which the previous formula would give me.

Anyone any ideas?