Concatenate two strings but format text differently

[stefanaalten]

I'd like to concatenate two text strings but format each part differently, like this:

cell A1: Title
cell B1: Subtitle

Concatenate in cell C1 as: Title Subtitle

The source cells (A1 & B1) are unformatted.

Easy to figure out the concatenation itself, but I don't know how to do the formatting. Can anyone please help?

 

[VoG]

Sorry, a formula cannot format a cell.