How to insert a symbol from a 3rd party TrueType Font file, into an Excel string & string formula?

[TheOnlySheet]

Currently, my Excel workbook uses symbols from the Calibri font family to represent actions:
◆ = 1 Action, ◇ = Free Action, ❖ = Reaction

But these are approximation of the symbols defined in a separate TTF file from the 3rd party. Here are the 'correct' symbols that I would like to use:

My question is:
Is is possible (assuming this specific TTF is available [i.e. installed] on the user's system) to replace a specific Character in a Calibri string to use the corresponding 'true' type symbol in the strings and formulas that display strings?

Thank you for your help!

 

[Jaafar Tribak]

Welcome to the forum.

Since the ttf is installed, can't you insert the symbols from Insert | Symbol ribbon button? However, this won't work with individual characters in formulaes results.

 

[TheOnlySheet]

Welcome to the forum.

Since the ttf is installed, can't you insert the symbols from Insert | Symbol ribbon button? However, this won't work with individual characters in formulaes results.

No, that is not what I need... Complex Formulas outputs string that uses these symbols... so I can't manually do any of this. It has to be a VBA thing - if it is even possible at all... (which I am not sure it is at this point...)

Cheers!
TOS

 

[Jaafar Tribak]

No, that is not what I need... Complex Formulas outputs string that uses these symbols... so I can't manually do any of this. It has to be a VBA thing - if it is even possible at all... (which I am not sure it is at this point...)

Cheers!
TOS

AFAIK, you can't format individual characters in formulas outputs strings. If however the formula returns one character only (ie:= the ttf symbol only) then I guess, you could possibly just format the font of the formula cell with your ttf font.