Formula to bring back result with soft return

[melsmiff]

I have in cell A1: 80
cell B1: 224/100
and in C1 the formula: =CONCATENATE(A1," ","(",B1,")")

I get the answer: 80 (224/100)

what I want is to split it onto 2 lines:

80
(224-100)

Any idea how this can be done?

[VBA Noob]

Please read forum rules below and add the link to the other forum

Cross posting is not permitted

=CONCATENATE(A1," " &CHAR(10),"(",B1,")")

then wrap cell

VBA Noob