Controlling Fonts When Using Excel Equations for Strings

[FracinDean]

How can the font or bold/italics/underline of only certain parts of a string equation result be changed when using equations? An example of what I would like to be able to do below:

="This is step number "&text($a$1,###)&" of "&text($B$1,###)&"."

But I would like to be able to change the numbers to bold font without changing the font of the words (as an example).

The above example results in the following appearance in the cell contents: "This is step number 2 of 27."

I would like it to appear as "This is step number 2 of 27."

 

[Fluff]

You cannot do that with a cell containing a formula.
You would have to convert the formula to a value, which defeats the point of the formula

 

[FracinDean]

Good to know. “A man’s gotta know his limitations.”

 

[Fluff]

You're welcome & thanks for the feedback.