How to concatenate and stack the result into one cell with a formula

[atf32]

Looking for a formula to concatenate a few items. However I want to stack the result in the same cell. I can do it manually, but want to do this with a formula.

Note: data can be anything

 

[Fluff]

Re: How to concatinate and stack the result into one cell with a formula

Something like

Excel 2013/2016
	A	B	C	D
1	North Yorkshire	Hambleton	Bagby & Thorntons	North Yorkshire Hambleton Bagby & Thorntons
Color

Cell Formulas
Range	Formula
D1	=A1&CHAR(10)&B1&CHAR(10)&C1

 

[atf32]

Re: How to concatinate and stack the result into one cell with a formula

Once again Fluff, you have the answers...... Thanks for the quick response.

 

[atf32]

Re: How to concatinate and stack the result into one cell with a formula

I want to add to this..... I'm curious. Is is possible to Bold only the first string and italicize only the last one?

 

[Fluff]

Re: How to concatinate and stack the result into one cell with a formula

Nope.
In order to do something like that you would need to remove the formula from the cell & replace it with the value.

 

[atf32]

Re: How to concatinate and stack the result into one cell with a formula

Thank you

 

[Fluff]

Re: How to concatinate and stack the result into one cell with a formula

You're welcome