How to retain subscripting/superscripting with CONCATENATE

K

Kenneth Dahl

I wish to concatenate molecular formulas in Excell cells
in which there are subscripted numbers. For example,
Al2O3 in A1 with SiO2 in B1, where all the numbers in both
instances are formatted as subscripts. If in C1 I type
the formula =CONCATENATE(A1," + ",B1), all the subscripted
numbers revert to unsubscripted text. How can I avoid
having this happen?
 
J

J.E. McGimpsey

Unfortunately, XL doesn't allow you to change character format in
calculated cells.

One potential workaround would be to use an event macro to
concatenate the cell contents, checking for character formatting and
applying the identical format.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top