Prev: directing a total to various cells dependent of its value
Next: Include a value from one cell within text of another cell.
From: orGTFO on 14 Apr 2010 10:46 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?
From: Pete_UK on 14 Apr 2010 11:26
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 <orG...(a)discussions.microsoft.com> 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? |