View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ricardo the Numpty Ricardo the Numpty is offline
external usenet poster
 
Posts: 1
Default 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?