Combining symbols w/ letters & numbers

CoogansBluff

Board Regular
Joined
Mar 7, 2021
Messages
59
Office Version
  1. 2013
Platform
  1. Windows
Below is a cell that combines a wingdings symbol with Calibri characters.

1682703837127.png


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?
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
You would need to use the same font like & use unichar 9670
Fluff.xlsm
KL
2◆(R2)9670
Master
Cell Formulas
RangeFormula
L2L2=UNICODE(K2)
 
Upvote 0
Solution
You're welcome & thanks for the feedback.
 
Upvote 0
Didn't take as much studying as I thought. It's pretty simple and opens up many creative possibilities for my project. Thanks again!
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,223,236
Messages
6,170,915
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top