Concatenation with Different Formatting

[mccornack]

Hello All,
My third and final request involves concatenating a row of cells, many of which have different formats. I need to combine this row of cells (adding spaces in between each word), while preserving the formatting of each individual cell in the final concatenation. For the life of me, I can't figure out how to achieve this. If anyone could lend a hand, or offer a few suggestions, I'd really really appreciate it! Thank you!

 

[Expiry]

You can use the text() formula. If B3 had 12/01/11 in it and C3 had 17. This formula would give you 12-Jan 17

=TEXT(B3,"dd-mmm")&" "&C3

 

[mccornack]

Sorry, the formatting I was referring to was font size and color. By the end of the project I'm working on, I'll have rows of cells, with one word in each of them, each with a (potentially) different color and size. I want to concatenate all the cells in the row while preserving each cell's format. Any thoughts or suggestions?