Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenation | Excel Discussion (Misc queries) | |||
Help with Concatenation | Excel Worksheet Functions | |||
Formatting when using concatenation. | Excel Discussion (Misc queries) | |||
Formatting when using concatenation. | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |