L
leon22
Hi,
I am trying to design a formula that concatenates in cell A3 th
content of cells A1 and A2 together, and by displaying the content o
cell A2 in superscript. This has to be done through a formula, as
want it to be dynamic, and be able to copy elsewhere in the worksheet.
A1 = CAR
A2 = (blue)
A3 should return CAR(blue), but the "(blue)" must be superscript.
P.S. I know this could be done by creating a custom function (usin
VB), but I would prefer doing it using standard Excel functions.
Any help is appreciated.
Thank
I am trying to design a formula that concatenates in cell A3 th
content of cells A1 and A2 together, and by displaying the content o
cell A2 in superscript. This has to be done through a formula, as
want it to be dynamic, and be able to copy elsewhere in the worksheet.
A1 = CAR
A2 = (blue)
A3 should return CAR(blue), but the "(blue)" must be superscript.
P.S. I know this could be done by creating a custom function (usin
VB), but I would prefer doing it using standard Excel functions.
Any help is appreciated.
Thank