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 |
All times are GMT +1. The time now is 03:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com