ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Concatenation and Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/261489-concatenation-formatting.html)

orGTFO

Concatenation and Formatting
 
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?

Pete_UK

Concatenation and Formatting
 
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?




All times are GMT +1. The time now is 09:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com