R
Ricardo the Numpty
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?
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?