Joining Formatted Cells

Hello All,

First time caller...Is it possible to join cells where text in those joined cells have different colors and have the joined cell retain all the various text colors? 

I've tried =Cell1 + Cell2... and =Join(Range) and both return combined text in default black text.

Thanks in advance for your feedback.


formatted cells.PNG



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!