How do I transfer the formatting in one cell to another

New Contributor

How do I keep the subscripts in a text in one cell when I use a formula to pull that content to another cell like using the Concat formula? 

1 Reply


I'm afraid that isn't possible. Excel does not support formatting part of the result of a formula differently from the rest.

You might request this feature in Excel using File > Feedback.