Possible to have ALT+ENTER function in a CONCATENATE formula?

Hi all, for formatting purposes I'm hoping to have the value for cell A1 and cell B1 to be stacked on top of each other in cell C1 - anybody have any luck with something like this?

Thanks!!
Scott

Make sure C1 is formatted to wrap text and then the below should do what you need.

Formula:

Please Login or Register  to view this content.

BSB