CONCATENATE and INDIRECT issue with return

[jayserna]

I am using the following formula =CONCATENATE(INDIRECT(M1&"!E12"),CHAR(10),CHAR(10),INDIRECT(M1&"!E64"))

The formula is retuning the correct data, but nor formatted the way I want. I need to pull two values based on the drop down selection. While it is retuning the data selections, it is placing them back-to-back and I would like them separated.

current:
Data 1Data 2

Need:
Data 1

Data 2

 

[MrKowz]

You need to enable word wrap for that cell.

 

[jayserna]

thanks