Settting the font for specific pieces of text

I have a problem with calc.
I have to insert, within a text in a cell formatted with a certain font, some symbols coming from other fonts.
The text in the cell is created by a formula to apply in many cells, so I need to set the font change in the formula.
How do I set a specific font for just a piece of string?

There is the Style Function, but it is general for the cell.

It can be done manually by selecting part of the text and applying the desired style.

It is impossible to format parts of formula result individually.

1 Like