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?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks