I have done some analysis and am now preparing to present the results in a table.
I have a formula in a cell that looks like this: (E15+E16)&" "&"("&TEXT(E17,"0.00%")&")"
The results from this are a cell that looks like this: 670 (1.96%)
Being a little pedantic here but is there a way to edit the text formula so that it is all in italics like this: 670 (1.96%) ?
Also, see how I added the brackets using the concat operator &. Wonder if there's a neater way by integrating it into the text formula?
I have a formula in a cell that looks like this: (E15+E16)&" "&"("&TEXT(E17,"0.00%")&")"
The results from this are a cell that looks like this: 670 (1.96%)
Being a little pedantic here but is there a way to edit the text formula so that it is all in italics like this: 670 (1.96%) ?
Also, see how I added the brackets using the concat operator &. Wonder if there's a neater way by integrating it into the text formula?