unichar

  1. DRSteele

    Remove Unwanted Characters from a Textstring

    Getting rid of unwanted characters in a cell's textstring can be achieved easily by creating a Table of acceptable UNICODEs and their corresponding UNICHARs. The Table (here named T_codes) can be expanded or contracted as needed. Here, we have just the usual set of English letters (26 Upper Case...
  2. DRSteele

    Utilising the function UNICHAR

    Sometimes we wish to find characters to place into our spreadsheets but are unsure where to look and how to find them. Function UNICHAR allows us to enter a number and it will report the character. Mike Girvin from ExcelIsFun recently created a youtube video that shows ways of listing them - as...
  3. gtd526

    UNICHAR code

    =IF(Q15>O15,UNICHAR(128314),UNICHAR(128315)),IF(Q15=O15,UNICHAR(61)) or =IF(Q15>O15,UNICHAR(128314)),IF(Q15<O15,UNICHAR(128315)),IF(Q15=O15,UNICHAR(61))<o15,unichar(128315)),if(q15=o15,unichar(61))<o15,unichar(128315)),if(q15=o15,unichar(61)) I've tried these formulas for UNICHAR symbol...

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