Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preserving text formats with Concatenate function
I feared that was indeed the case.
Thanks much for making it definitive. -j "Frank Kabel" wrote in message ... Hi formulas can't return formats. they only return values. So no chance to preserve the format infomation within you concatenation formula -- Regards Frank Kabel Frankfurt, Germany rufus wrote: hi all, apologies for the potential double post, but my original one does not seem to have ever made it out to google groups from my local news server. At any rate, here's the question: I need to combine a series of cells that each have different sorts of text formatting involved. For example: -Cell A1 could have the word "train" in standard 12 font -Cell B1 could have the word "train" in bold 12 font -Cell C1 could have the word "train" in standard 14 font etc. For the life of me I can't find a way to preserve the formatting of each entry once they are combined into a cell using either concatenate or simple '&' functions. Just to head off a possible suggestion, I have tried specifically formatting a given cell with the combination of font sizes and bolding that I need, and then just doing a "copy - paste special - formats" onto my combined cell. This worked, but unfortunately, the cells I need to combine usually do not contain the same numbers of digits and letters, so there's no way to automate this process in a way that would actually save any time. Thanks much for any suggestions. -j |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get different text formats in a concatenate function | Excel Discussion (Misc queries) | |||
Replace Function Removes Text Formats In Cell | Excel Discussion (Misc queries) | |||
use concatenate function to put carrage returns in a text string | Excel Worksheet Functions | |||
Custom number formats in TEXT function | Excel Worksheet Functions | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel |