Excel functions do not return formatting, so yes, you will have to use
VBA to do that (unless the formatting was applied through conditional
formatting).

Hope this helps.

Pete

On Apr 14, 3:46*pm, orGTFO wrote:
I would like to combine text from different cells that has formatting such as
subscript/superscript which is removed upon concatenation. *Does Excel have
this capability? *Or will I need to venture into the world of VBA?