Changing font size within a formula

[doowop5000]

Hi all-

I'm doing a formula such as:
="Revenue= "&text(a1,"$0,00#")&" ("&text(a2,"0.?%")&")"
where:
a1= Revenue $amount
a2= %gross margin

so that it'll appear as:
Revenue= £100,000 (48%)

This works, but I want the "(48%)" to be a smaller font size than revenue bit - any ideas??

Many thanks

[Andy Pope]

You can not format parts of a cells with a formula in it.
If you really what the formatting you will need to use 2 cells.