Combining symbols w/ letters & numbers

[CoogansBluff]

Below is a cell that combines a wingdings symbol with Calibri characters.

Let's say that's in cell A1.

Then in another cell somewhere, I have a formula =A1 ... Which predictably converts it to all Calibri or all wingdings.

Is there a way to have the formula show exactly what's in cell A1 without converting it to either calibri or wingdings?

Or do I need to find a font that accommodates symbols and letters? If so, any suggestions?

 

[Fluff]

You would need to use the same font like & use unichar 9670

Fluff.xlsm
	K	L
2	◆(R2)	9670
Master

Cell Formulas
Range	Formula
L2	L2	=UNICODE(K2)

 

[CoogansBluff]

Will have to study this. Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[CoogansBluff]

Didn't take as much studying as I thought. It's pretty simple and opens up many creative possibilities for my project. Thanks again!

 

[Fluff]

My pleasure.

 

[CoogansBluff]

Made a discovery ... If use a unichar formula - ie, =unichar(9730) - to get a symbol/image, etc., I can then use ASAP utilities to convert the formula to ''its calculated value,'' the result is a symbol/image that can be used like it's a letter or number in any font.

For example, by converting the ◆ and ② symbols produced by the unichar formula to 'their calculated values,' they become like any other letter or symbol.

◆②Sunshine