What Is It Called When Characters Turn Into Special Characters In Excel?
Special character symbols from the set of Unicode characters similar ☐, ☑, ⚐, ⚑, ▲, and ▼ can be useful for many different things in Excel. You tin use them in drop-downward lists, charts, custom number formats, dot plots and in-prison cell pictographs. As the Office software and spider web browsers proceed to support the display of more symbols, I expect the use of special characters volition arrive possible to do even more cool stuff with Excel.
I created this folio so that I would have a quick reference for the types of symbols that I use frequently in Excel. Why? Because the Insert Symbol feature in Excel doesn't include many of the symbols I like to use, and 1 of the easy ways to get a symbol into Excel is to copy/paste the symbol from a spider web folio.
Bound Ahead To:
- How to Insert a Symbol in Excel
- Using the UNICODE and UNICHAR Functions
- Unicode Characters in Drop-Down Lists
- Unicode Characters in Custom Number Formats
- Using REPT() for Data Bars & Pictographs
- Some Favorite Unicode Characters
- Examples in Templates
- List of Emojis/Emoticons
How to Insert a Symbol in Excel
1. From the Spider web: Copy and Paste
In that location are many places on the internet to observe lists of unicode characters. Do a google search for "unicode ...". Usually, you can just select the unicode character from your browser and press Ctrl+c to copy it, then Ctrl+v to paste it into Excel. If you are editing the text or formula within a cell, then it will paste just the character (instead of the formatting from the web folio).
My favorite searchable resources for seeing what emojis look like in other software is unicode.org
2. Excel: Insert > Symbol
You lot can scan some of the unicode characters using the Insert > Symbol dialog. It volition tell you lot the proper noun of the symbol as well every bit the character code.
The Insert Symbol Tool in Excel 2016
IMPORTANT: The Arial font doesn't list many Unicode symbols, so change the Font to "Segoe UI Symbol" then in the Subset dropdown, select "Miscellaneous Symbols" and start scrolling down. Unfortunately, there isn't a good search characteristic to observe what you lot desire.
Y'all can use the hexidecimal Graphic symbol lawmaking value to display a character in html by entering it as &#xNNNN; where NNNN is the hex code. Example: ▲ (▲)
If you have found the Decimal code (which I have listed on this page for many symbols), you brandish it in html as &#NNNN; (leaving out the "x").
3. Windows: Inserting Special Symbols Using ALT Codes
Some special characters can be inserted by pressing ALT+#, where the # is entered using the number pad. Hold the Alt key while you press the number sequence and then lift up on the ALT key. I've only learned one code past heart: ALT+0169 is the © symbol. See the references below for a list of ALT codes.
4. Windows 10: Emoji Keyboard Console
The new Windows x update added a way to insert emojis from the keyboard. Open the Emoji Keyboard Panel by pressing ⊞ Win+. (Window primal + Period) or ⊞ Win+;.
The Insert Symbol Tool in Excel 2016
I employ this a LOT (only took a dozen or so times before I had the shortcut memorized), and you tin can see from my screenshot which emojis I employ most recently. ✔ 🙂
five. Excel: Create Shortcuts to Insert Symbols Using Auto-Correct
You may already be familiar with how (c) automatically changes to © and (r) changes to ® in Role applications. When using this feature, you type (c) and then either press Enter or another character, and Excel changes it to ©. If you don't want that to happen, y'all tin can press Ctrl+z to undo the machine-right.
The absurd thing is that you tin add together your own custom shortcuts for the special characters or symbols that you use the most.
In Excel 2013/2016, get to File > Options > Proofing and click on Auto-correct Options. A window will pop that lets you define shortcuts for special symbols. I've been doing this for years, and have plant that using the abbreviated proper name or graphical representation in parentheses works keen. For example (plusmn) for ±, and (middot) for the dot y'all identify between units in labels like N·yard (Newton-meter).
Files > Options > Proofing > Autocorrect Options
The table below lists just SOME of the thousands of symbols you might want to utilise. Some of the names in parentheses are the same named used for the HTML equivalent, such as ° for ° and ÷ for ÷. Others are just examples of what I like to use such as (->>) for ►.
| (plusmn) | ± | (alpha) | α | (capalpha) | Α | (/\) | ▲ |
| (deg) | ° | (beta) | β | (capbeta) | Β | (\/) | ▼ |
| (micro) | µ | (gamma) | γ | (capgamma) | Γ | (<<-) | ◄ |
| (ohm) | Ω | (delta) | δ | (capdelta) | Δ | (->>) | ► |
| (infin) | ∞ | (epsilon) | ε | (capepsilon) | Ε | (--) | ▬ |
| (middot) | · | (zeta) | ζ | (capzeta) | Ζ | (larr) | ← |
| (bull) | • | (eta) | η | (capeta) | Η | (rarr) | → |
| (ge) | ≥ | (theta) | θ | (captheta) | Θ | (uarr) | ↑ |
| (le) | ≤ | (kappa) | κ | (capkappa) | Κ | (darr) | ↓ |
| (ne) | ≠ | (lambda) | λ | (caplambda) | Λ | (star) | ★ |
| (asymp) | ≈ | (mu) | μ | (capmu) | Μ | (starempty) | ☆ |
| (dot) | ˙ | (xi) | ξ | (capxi) | Ξ | (heart) | ❤ |
| (equiv) | ≡ | (pi) | π | (cappi) | Π | (lightcheck) | ✓ |
| (function) | ∂ | (rho) | ρ | (caprho) | Ρ | (check) | ✔ |
| (change) | ∆ | (tau) | τ | (captau) | Τ | (boxE) | ☐ |
| (del) | ∇ | (omega) | ω | (capomega) | Ω | (boxC) | ☑ |
| (times) | × | (sigma) | σ | (capsigma) | Σ | (boxX) | ☒ |
| (divide) | ÷ | (phi) | φ | (capphi) | Φ | (lightmark) | ✗ |
| (radic) | √ | (circ) | ⬤ | (block) | █ | (mark) | ✘ |
| (sum) | ∑ | (circempty) | ◯ | (smallblock) | ▇ | (flag) | ⚑ |
| (prod) | ∏ | (cutting) | ✁ | (note) | ♪ | (flagempty) | ⚐ |
Using the UNICHAR and UNICODE functions
The UNICODE and UNICHAR functions have been available since Excel 2013 and are like to the older CODE and CHAR functions.
The UNICHAR part is perhaps the virtually useful, because it will return the character for a given decimal value (UTF-8 and UTF-16), like this:
=UNICHAR(10004) returns ✔
The UNICODE function does the reverse. Information technology returns the numeric decimal Unicode value for the get-go character in a text cord, like this:
=UNICODE("✔") returns 10004
If you want to endeavour something fancy, you can apply the following array formula (printing Ctrl+Shift+Enter after entering an array formula) to return an assortment of Unicode values for each of the characters in a text cord.
=UNICODE(MID(text_string,ROW(INDIRECT("1:"&LEN(text_string))),1))
Symbols in Data Validation Drop-Downs
Using special symbols or dingbats within drib-downward lists is a great substitute for a checkbox in Excel. I've demonstrated this in various task listing and action item templates. You can likewise use stars or flag symbols for flagging priority items in a list.
Attempt It - Create a Substitute for a Checkbox in Excel: Open a new worksheet in Excel, select cell A1 then get to Data > Information Validation and select the List option. Copy the following characters (including the comma), and paste them into the Source field: ☐, ☑
Check Marks and Check Boxes
| ✓ 10003 | ✔ 10004 | ✕ 10005 | ✖ 10006 | ✗ 10007 | ✘ 10008 | ☐ 9744 | ☑ 9745 | ☒ 9746 |
Flags and Circles
| ⚑ 9873 | ⚐ 9872 | ⬤ 11044 | ⵔ 11604 | ◯ 9711 | 🏁 127937 | 🏴 127988 | 🚩 128681 |
Symbols for Milestones
Symbols for Priorities
| 🔥 128293 hot | ❆ 10054 cold | ♨ 9832 warm |
See the CRM Template for an instance of how these symbols are used.
Symbols for Ratings
| ★ 9733 | ☆ 9734 | ❤ 10084 | ♥ 9829 | ♡ 9825 | 👍 128077 | 👎 128078 |
The feature comparing template demonstrates how you can apply a data validation drop-down list to create a star-rating past entering ★,★★,★★★ into the Source box for the list.
Emoji Rating System
| 😍 128525 | 😃 128515 | 🙂 128578 | 😐 128528 | 😕 128533 | 🙁 128577 | 😠 128544 |
For a larger list of emoticons, see this folio.
Data Bars and Pictographs
Pictographs or Dot Plots
You tin can use the =REPT(text,number_times) function to repeat a character, as demonstrated in the article "Create a Dot Plot in Excel". Below is an example of a very basic in-prison cell pictograph.
In-Jail cell Dot Plot using REPT
One of the issues with using symbols for pictographs is that the REPT() function cannot display a fraction of a symbol. If you need a graph to show decimal values rather than just whole numbers, you can create a small moving picture (such every bit a screen capture of a Unicode character) and utilise it inside an Excel chart to create a pictograph similar the example below.
Sample Pictograph in Excel using a Bar Chart and Picture Fill
Data Bars
Information bars are oft used in spreadsheet dashboards to show in-prison cell bar graphs. They can also be used for progress bars if the cell is scaled to 0%-100%. You may not need to employ this technique for in-cell graphics in Excel whatsoever more because of the awesome conditional formatting options. However, Google Sheets does not take in-cell information bars nonetheless, so using the REPT() function is 1 way to create something like a data bar (encounter the epitome beneath).
Data Bar in Google Sheets
The table below lists the main characters I use for this technique. Note that although there are some skinny bars (similar 9612), for data bars you lot demand to apply the characters that do non include any blank space.
| ▆ 9606 | ▇ 9607 | █ 9608 | ▌ 9612 |
| ▆▆▆▆ | ▇▇▇▇ | ████ | ▌▌▌▌ |
Sprint Progress Charts
What I call a "dart chart" or "sprint progress chart" is a simple graph that shows progress relative to the amount of fourth dimension left. This technique can be useful every bit a visual assist in Agile Product Development. Download the Kanban Lath Template to encounter information technology in action. The "sprint" period is represented as a number of days, with a flag for each 24-hour interval. The filled-in flags ⚑ represent the percent completed and the sentry or hourglass symbol represents the current mean solar day. The example chart below is showing multiple teams' race against time.
A Sprint Progress Chart Using the REPT Function
Here is the formula for creating the in-cell sprint chart:
sprint = xiv (# of days in the sprint) progress = 34.v% complete = ROUND(sprint*progress,0) time = IF(TODAY()<start_date,0,IF(TODAY()>(start_date+sprint),sprint,TODAY()-start_date)) =REPT("⚑",MIN(time,complete)) & REPT("⚐",MAX(0,time-complete)) & "⌛" & REPT("⚑",MAX(0,consummate-time)) & REPT("⚐",dart-MAX(time,complete)) & "🏁"
Other Useful Symbols
Triangles / Arrows
| ▬ 9644 | ▲ 9650 | ▼ 9660 | ► 9658 | ◄ 9668 |
| ALT+22 | ALT+xxx | ALT+31 | ALT+xvi | ALT+17 |
These are the symbols I like to utilise for up/downwardly signals. The dash is obviously not an arrow, merely the this dash symbol works well as a "zero" when using the up/downward symbols in custom number formats (encounter the examples beneath). In that location are a LOT of different kinds of arrows, but I use these triangles more oftentimes than other arrows. See my Unicode Symbols folio for a huge list of arrows.
Scissors
| ✀ 9984 | ✁ 9985 | ✂ 9986 | ✃ 9987 |
| ✁----------------------------- | |||
In combination with a custom number format of "@*-" and merged cells, the scissors tin exist used in forms like a remittance slip on a billing invoice to create a guide for cutting.
Some Sports Symbols
| ⚽ 9917 | ⚾ 9918 | 🏈 127944 | 🏀 127936 | 🚲 128690 | ⛳ 9971 | 🎾 127934 | ⛷ 9975 | ⛸ 9976 |
Fourth dimension and Clocks
| ⌚ 8986 | ⏰ 9200 | ⌛ 8987 | ⏳ 9203 | 🕓 128339 | 🕜 128348 |
There are symbols for each 60 minutes and half hour on the clock. See this page for a full list.
Moon Phases
| 🌑 127761 | 🌒 127762 | 🌓 127763 | 🌔 127764 | 🌕 127765 | 🌖 127766 | 🌗 127767 | 🌘 127768 | 🌙 127769 |
These symbols can be used to create a Moon Phase Agenda in Excel. The template I created uses the symbols inside conditional formatting rules and custom number formats.
Symbols in Custom Number Formats
Special characters can exist used inside custom number formats as a substitute for conditional formatting icons. You can as well use this technique to format numbers that announced in charts! Have a look at the examples beneath.
Examples using custom number formats with special symbols
The following custom format codes were used to generate the instance shown in the screenshot in a higher place:
⬤,ⵔ : [Color10]⬤* 0;[Red]⬤* -0;[Color16]ⵔ* 0;@ ▲,▬,▼ : [Color10]▲* 0;[Ruby]▼* -0;[Color16]▬* 0;@ ⚑,⚐ : [Color10]⚑* 0;[Red]⚑* -0;[Color16]⚐* 0;@ ☑,☐,☒ : [Color10]☑* 0;[Red]☒* -0;[Color16]☐* 0;@
If you haven't seen color codes similar [ColorN] used in custom number formats before, you tin can read this article. I created the graphic below to show how the [ColorN] codes correlate to the the old .xls colour palette. I created the squares (█▌) next to the colour codes by combining the █ and ▌ characters.
Color codes for custom number formats (based on the default color palette)
Examples in Templates
i. Feature Comparing Template - This template demonstrates many dissimilar means of using unicode characters and provisional formatting, including check boxes and star-ratings within drop-downs.
✓, ✔, 🗶, ✗, ✘, ✪, ★, ☐, ☑, ☒, ⚐, ⚑, ◆, ⬧
★,★★,★★★,★★★★,★★★★★
2. Attendance Sheet Template - This template shows how you lot can use fun symbols for taking omnipresence instead of a boring "x". The COUNTA() function volition count the cells that aren't blank, so it doesn't matter what symbol you lot apply. These characters look even ameliorate in the Excel app on an iPhone.
three. Blood Carbohydrate Chart Template - You tin add some fun to perhaps an otherwise deadening chart or log by adding emojis within drop-downwards lists (and even in the chart itself, past using screenshot images of emojis equally data indicate markers).
Emojis, Emoticons, and other Miscellaneous Symbols
The Unicode emojis and emoticons do non necessarily appear the same in all browsers and apps, but it's worth pointing out that near of these symbols can be displayed in new versions of Excel. The post-obit tabular array provides a quick way to look at some of these symbols. To browse a huge list of Unicode symbols, see my Unicode Symbols folio.
To utilise ane of these characters in Excel: you can copy/paste a character from the tabular array below. Afterward copying the emoji graphic symbol, you can paste it within a formula or anywhere else that you might paste a text character.
| 😀 128512 | 😁 128513 | 😂 128514 | 😃 128515 | 😄 128516 | 😅 128517 | 😆 128518 | 😇 128519 | 😈 128520 | 😉 128521 | 😊 128522 | 😋 128523 |
| 😌 128524 | 😍 128525 | 😎 128526 | 😏 128527 | 😐 128528 | 😑 128529 | 😒 128530 | 😓 128531 | 😔 128532 | 😕 128533 | 😖 128534 | 😗 128535 |
| 😘 128536 | 😙 128537 | 😚 128538 | 😛 128539 | 😜 128540 | 😝 128541 | 😞 128542 | 😟 128543 | 😠 128544 | 😡 128545 | 😢 128546 | 😣 128547 |
| 😤 128548 | 😥 128549 | 😦 128550 | 😧 128551 | 😨 128552 | 😩 128553 | 😪 128554 | 😫 128555 | 😬 128556 | 😭 128557 | 😮 128558 | 😯 128559 |
| 😰 128560 | 😱 128561 | 😲 128562 | 😳 128563 | 😴 128564 | 😵 128565 | 😶 128566 | 😷 128567 | 😸 128568 | 😹 128569 | 😺 128570 | 😻 128571 |
| 😼 128572 | 😽 128573 | 😾 128574 | 😿 128575 | 🙀 128576 | 🙁 128577 | 🙂 128578 | 🙃 128579 | 🙄 128580 | 🙅 128581 | 🙆 128582 | 🙇 128583 |
| 🙈 128584 | 🙉 128585 | 🙊 128586 | 🙋 128587 | 🙌 128588 | 🙍 128589 | 🙎 128590 | 🙏 128591 | ||||
| 🚀 128640 | 🚁 128641 | 🚂 128642 | 🚃 128643 | 🚄 128644 | 🚅 128645 | 🚆 128646 | 🚇 128647 | 🚈 128648 | 🚉 128649 | 🚊 128650 | 🚋 128651 |
| 🚌 128652 | 🚍 128653 | 🚎 128654 | 🚏 128655 | 🚐 128656 | 🚑 128657 | 🚒 128658 | 🚓 128659 | 🚔 128660 | 🚕 128661 | 🚖 128662 | 🚗 128663 |
| 🚘 128664 | 🚙 128665 | 🚚 128666 | 🚛 128667 | 🚜 128668 | 🚝 128669 | 🚞 128670 | 🚟 128671 | 🚠 128672 | 🚡 128673 | 🚢 128674 | 🚣 128675 |
| 🚤 128676 | 🚥 128677 | 🚦 128678 | 🚧 128679 | 🚨 128680 | 🚩 128681 | 🚪 128682 | 🚫 128683 | 🚬 128684 | 🚭 128685 | 🚮 128686 | 🚯 128687 |
| 🚰 128688 | 🚱 128689 | 🚲 128690 | 🚳 128691 | 🚴 128692 | 🚵 128693 | 🚶 128694 | 🚷 128695 | 🚸 128696 | 🚹 128697 | 🚺 128698 | 🚻 128699 |
| 🚼 128700 | 🚽 128701 | 🚾 128702 | 🚿 128703 | 🛀 128704 | 🛁 128705 | 🛂 128706 | 🛃 128707 | 🛄 128708 | 🛅 128709 | 🛆 128710 | 🛇 128711 |
| 🛈 128712 | 🛉 128713 | 🛊 128714 | 🛋 128715 | 🛌 128716 | 🛍 128717 | 🛎 128718 | 🛏 128719 | 🛐 128720 | 🛑 128721 | 🛒 128722 | 🛓 128723 |
| 🛠 128736 | 🛡 128737 | 🛢 128738 | 🛣 128739 | 🛤 128740 | 🛥 128741 | 🛦 128742 | 🛧 128743 | 🛨 128744 | 🛩 128745 | 🛪 128746 | 🛫 128747 |
| 🛬 128748 | 128749 | 128750 | 128751 | 🛰 128752 | 🛱 128753 | 🛲 128754 | 🛳 128755 | 🛴 128756 | 🛵 128757 | 🛶 128758 | 🛷 128759 |
| 🌀 127744 | 🌁 127745 | 🌂 127746 | 🌃 127747 | 🌄 127748 | 🌅 127749 | 🌆 127750 | 🌇 127751 | 🌈 127752 | 🌉 127753 | 🌊 127754 | 🌋 127755 |
| 🌌 127756 | 🌍 127757 | 🌎 127758 | 🌏 127759 | 🌐 127760 | 🌑 127761 | 🌒 127762 | 🌓 127763 | 🌔 127764 | 🌕 127765 | 🌖 127766 | 🌗 127767 |
| 🌘 127768 | 🌙 127769 | 🌚 127770 | 🌛 127771 | 🌜 127772 | 🌝 127773 | 🌞 127774 | 🌟 127775 | 🌠 127776 | 🌡 127777 | 🌢 127778 | 🌣 127779 |
| 🌤 127780 | 🌥 127781 | 🌦 127782 | 🌧 127783 | 🌨 127784 | 🌩 127785 | 🌪 127786 | 🌫 127787 | 🌬 127788 | 🌭 127789 | 🌮 127790 | 🌯 127791 |
| 🌰 127792 | 🌱 127793 | 🌲 127794 | 🌳 127795 | 🌴 127796 | 🌵 127797 | 🌶 127798 | 🌷 127799 | 🌸 127800 | 🌹 127801 | 🌺 127802 | 🌻 127803 |
| 🌼 127804 | 🌽 127805 | 🌾 127806 | 🌿 127807 | 🍀 127808 | 🍁 127809 | 🍂 127810 | 🍃 127811 | 🍄 127812 | 🍅 127813 | 🍆 127814 | 🍇 127815 |
| 🍈 127816 | 🍉 127817 | 🍊 127818 | 🍋 127819 | 🍌 127820 | 🍍 127821 | 🍎 127822 | 🍏 127823 | 🍐 127824 | 🍑 127825 | 🍒 127826 | 🍓 127827 |
| 🍔 127828 | 🍕 127829 | 🍖 127830 | 🍗 127831 | 🍘 127832 | 🍙 127833 | 🍚 127834 | 🍛 127835 | 🍜 127836 | 🍝 127837 | 🍞 127838 | 🍟 127839 |
| 🍠 127840 | 🍡 127841 | 🍢 127842 | 🍣 127843 | 🍤 127844 | 🍥 127845 | 🍦 127846 | 🍧 127847 | 🍨 127848 | 🍩 127849 | 🍪 127850 | 🍫 127851 |
| 🍬 127852 | 🍭 127853 | 🍮 127854 | 🍯 127855 | 🍰 127856 | 🍱 127857 | 🍲 127858 | 🍳 127859 | 🍴 127860 | 🍵 127861 | 🍶 127862 | 🍷 127863 |
| 🍸 127864 | 🍹 127865 | 🍺 127866 | 🍻 127867 | 🍼 127868 | 🍽 127869 | 🍾 127870 | 🍿 127871 | 🎀 127872 | 🎁 127873 | 🎂 127874 | 🎃 127875 |
| 🎄 127876 | 🎅 127877 | 🎆 127878 | 🎇 127879 | 🎈 127880 | 🎉 127881 | 🎊 127882 | 🎋 127883 | 🎌 127884 | 🎍 127885 | 🎎 127886 | 🎏 127887 |
| 🎐 127888 | 🎑 127889 | 🎒 127890 | 🎓 127891 | 🎔 127892 | 🎕 127893 | 🎖 127894 | 🎗 127895 | 🎘 127896 | 🎙 127897 | 🎚 127898 | 🎛 127899 |
| 🎜 127900 | 🎝 127901 | 🎞 127902 | 🎟 127903 | 🎠 127904 | 🎡 127905 | 🎢 127906 | 🎣 127907 | 🎤 127908 | 🎥 127909 | 🎦 127910 | 🎧 127911 |
| 🎨 127912 | 🎩 127913 | 🎪 127914 | 🎫 127915 | 🎬 127916 | 🎭 127917 | 🎮 127918 | 🎯 127919 | 🎰 127920 | 🎱 127921 | 🎲 127922 | 🎳 127923 |
| 🎴 127924 | 🎵 127925 | 🎶 127926 | 🎷 127927 | 🎸 127928 | 🎹 127929 | 🎺 127930 | 🎻 127931 | 🎼 127932 | 🎽 127933 | 🎾 127934 | 🎿 127935 |
| 🏀 127936 | 🏁 127937 | 🏂 127938 | 🏃 127939 | 🏄 127940 | 🏅 127941 | 🏆 127942 | 🏇 127943 | 🏈 127944 | 🏉 127945 | 🏊 127946 | 🏋 127947 |
| 🏌 127948 | 🏍 127949 | 🏎 127950 | 🏏 127951 | 🏐 127952 | 🏑 127953 | 🏒 127954 | 🏓 127955 | 🏔 127956 | 🏕 127957 | 🏖 127958 | 🏗 127959 |
| 🏘 127960 | 🏙 127961 | 🏚 127962 | 🏛 127963 | 🏜 127964 | 🏝 127965 | 🏞 127966 | 🏟 127967 | 🏠 127968 | 🏡 127969 | 🏢 127970 | 🏣 127971 |
| 🏤 127972 | 🏥 127973 | 🏦 127974 | 🏧 127975 | 🏨 127976 | 🏩 127977 | 🏪 127978 | 🏫 127979 | 🏬 127980 | 🏭 127981 | 🏮 127982 | 🏯 127983 |
| 🏰 127984 | 🏱 127985 | 🏲 127986 | 🏳 127987 | 🏴 127988 | 🏵 127989 | 🏶 127990 | 🏷 127991 | 🏸 127992 | 🏹 127993 | 🏺 127994 | 🏻 127995 |
| 🏼 127996 | 🏽 127997 | 🏾 127998 | 🏿 127999 | 🐀 128000 | 🐁 128001 | 🐂 128002 | 🐃 128003 | 🐄 128004 | 🐅 128005 | 🐆 128006 | 🐇 128007 |
| 🐈 128008 | 🐉 128009 | 🐊 128010 | 🐋 128011 | 🐌 128012 | 🐍 128013 | 🐎 128014 | 🐏 128015 | 🐐 128016 | 🐑 128017 | 🐒 128018 | 🐓 128019 |
| 🐔 128020 | 🐕 128021 | 🐖 128022 | 🐗 128023 | 🐘 128024 | 🐙 128025 | 🐚 128026 | 🐛 128027 | 🐜 128028 | 🐝 128029 | 🐞 128030 | 🐟 128031 |
| 🐠 128032 | 🐡 128033 | 🐢 128034 | 🐣 128035 | 🐤 128036 | 🐥 128037 | 🐦 128038 | 🐧 128039 | 🐨 128040 | 🐩 128041 | 🐪 128042 | 🐫 128043 |
| 🐬 128044 | 🐭 128045 | 🐮 128046 | 🐯 128047 | 🐰 128048 | 🐱 128049 | 🐲 128050 | 🐳 128051 | 🐴 128052 | 🐵 128053 | 🐶 128054 | 🐷 128055 |
| 🐸 128056 | 🐹 128057 | 🐺 128058 | 🐻 128059 | 🐼 128060 | 🐽 128061 | 🐾 128062 | 🐿 128063 | 👀 128064 | 👁 128065 | 👂 128066 | 👃 128067 |
| 👄 128068 | 👅 128069 | 👆 128070 | 👇 128071 | 👈 128072 | 👉 128073 | 👊 128074 | 👋 128075 | 👌 128076 | 👍 128077 | 👎 128078 | 👏 128079 |
| 👐 128080 | 👑 128081 | 👒 128082 | 👓 128083 | 👔 128084 | 👕 128085 | 👖 128086 | 👗 128087 | 👘 128088 | 👙 128089 | 👚 128090 | 👛 128091 |
| 👜 128092 | 👝 128093 | 👞 128094 | 👟 128095 | 👠 128096 | 👡 128097 | 👢 128098 | 👣 128099 | 👤 128100 | 👥 128101 | 👦 128102 | 👧 128103 |
| 👨 128104 | 👩 128105 | 👪 128106 | 👫 128107 | 👬 128108 | 👭 128109 | 👮 128110 | 👯 128111 | 👰 128112 | 👱 128113 | 👲 128114 | 👳 128115 |
| 👴 128116 | 👵 128117 | 👶 128118 | 👷 128119 | 👸 128120 | 👹 128121 | 👺 128122 | 👻 128123 | 👼 128124 | 👽 128125 | 👾 128126 | 👿 128127 |
| 💀 128128 | 💁 128129 | 💂 128130 | 💃 128131 | 💄 128132 | 💅 128133 | 💆 128134 | 💇 128135 | 💈 128136 | 💉 128137 | 💊 128138 | 💋 128139 |
| 💌 128140 | 💍 128141 | 💎 128142 | 💏 128143 | 💐 128144 | 💑 128145 | 💒 128146 | 💓 128147 | 💔 128148 | 💕 128149 | 💖 128150 | 💗 128151 |
| 💘 128152 | 💙 128153 | 💚 128154 | 💛 128155 | 💜 128156 | 💝 128157 | 💞 128158 | 💟 128159 | 💠 128160 | 💡 128161 | 💢 128162 | 💣 128163 |
| 💤 128164 | 💥 128165 | 💦 128166 | 💧 128167 | 💨 128168 | 💩 128169 | 💪 128170 | 💫 128171 | 💬 128172 | 💭 128173 | 💮 128174 | 💯 128175 |
| 💰 128176 | 💱 128177 | 💲 128178 | 💳 128179 | 💴 128180 | 💵 128181 | 💶 128182 | 💷 128183 | 💸 128184 | 💹 128185 | 💺 128186 | 💻 128187 |
| 💼 128188 | 💽 128189 | 💾 128190 | 💿 128191 | 📀 128192 | 📁 128193 | 📂 128194 | 📃 128195 | 📄 128196 | 📅 128197 | 📆 128198 | 📇 128199 |
| 📈 128200 | 📉 128201 | 📊 128202 | 📋 128203 | 📌 128204 | 📍 128205 | 📎 128206 | 📏 128207 | 📐 128208 | 📑 128209 | 📒 128210 | 📓 128211 |
| 📔 128212 | 📕 128213 | 📖 128214 | 📗 128215 | 📘 128216 | 📙 128217 | 📚 128218 | 📛 128219 | 📜 128220 | 📝 128221 | 📞 128222 | 📟 128223 |
| 📠 128224 | 📡 128225 | 📢 128226 | 📣 128227 | 📤 128228 | 📥 128229 | 📦 128230 | 📧 128231 | 📨 128232 | 📩 128233 | 📪 128234 | 📫 128235 |
| 📬 128236 | 📭 128237 | 📮 128238 | 📯 128239 | 📰 128240 | 📱 128241 | 📲 128242 | 📳 128243 | 📴 128244 | 📵 128245 | 📶 128246 | 📷 128247 |
| 📸 128248 | 📹 128249 | 📺 128250 | 📻 128251 | 📼 128252 | 📽 128253 | 📾 128254 | 📿 128255 | 🔀 128256 | 🔁 128257 | 🔂 128258 | 🔃 128259 |
| 🔄 128260 | 🔅 128261 | 🔆 128262 | 🔇 128263 | 🔈 128264 | 🔉 128265 | 🔊 128266 | 🔋 128267 | 🔌 128268 | 🔍 128269 | 🔎 128270 | 🔏 128271 |
| 🔐 128272 | 🔑 128273 | 🔒 128274 | 🔓 128275 | 🔔 128276 | 🔕 128277 | 🔖 128278 | 🔗 128279 | 🔘 128280 | 🔙 128281 | 🔚 128282 | 🔛 128283 |
| 🔜 128284 | 🔝 128285 | 🔞 128286 | 🔟 128287 | 🔠 128288 | 🔡 128289 | 🔢 128290 | 🔣 128291 | 🔤 128292 | 🔥 128293 | 🔦 128294 | 🔧 128295 |
| 🔨 128296 | 🔩 128297 | 🔪 128298 | 🔫 128299 | 🔬 128300 | 🔭 128301 | 🔮 128302 | 🔯 128303 | 🔰 128304 | 🔱 128305 | 🔲 128306 | 🔳 128307 |
| 🔴 128308 | 🔵 128309 | 🔶 128310 | 🔷 128311 | 🔸 128312 | 🔹 128313 | 🔺 128314 | 🔻 128315 | 🔼 128316 | 🔽 128317 | 🔾 128318 | 🔿 128319 |
| 🕀 128320 | 🕁 128321 | 🕂 128322 | 🕃 128323 | 🕄 128324 | 🕅 128325 | 🕆 128326 | 🕇 128327 | 🕈 128328 | 🕉 128329 | 🕊 128330 | 🕋 128331 |
| 🕌 128332 | 🕍 128333 | 🕎 128334 | 🕏 128335 | 🕐 128336 | 🕑 128337 | 🕒 128338 | 🕓 128339 | 🕔 128340 | 🕕 128341 | 🕖 128342 | 🕗 128343 |
| 🕘 128344 | 🕙 128345 | 🕚 128346 | 🕛 128347 | 🕜 128348 | 🕝 128349 | 🕞 128350 | 🕟 128351 | 🕠 128352 | 🕡 128353 | 🕢 128354 | 🕣 128355 |
| 🕤 128356 | 🕥 128357 | 🕦 128358 | 🕧 128359 | 🕨 128360 | 🕩 128361 | 🕪 128362 | 🕫 128363 | 🕬 128364 | 🕭 128365 | 🕮 128366 | 🕯 128367 |
| 🕰 128368 | 🕱 128369 | 🕲 128370 | 🕳 128371 | 🕴 128372 | 🕵 128373 | 🕶 128374 | 🕷 128375 | 🕸 128376 | 🕹 128377 | 🕺 128378 | 🕻 128379 |
| 🕼 128380 | 🕽 128381 | 🕾 128382 | 🕿 128383 | 🖀 128384 | 🖁 128385 | 🖂 128386 | 🖃 128387 | 🖄 128388 | 🖅 128389 | 🖆 128390 | 🖇 128391 |
| 🖈 128392 | 🖉 128393 | 🖊 128394 | 🖋 128395 | 🖌 128396 | 🖍 128397 | 🖎 128398 | 🖏 128399 | 🖐 128400 | 🖑 128401 | 🖒 128402 | 🖓 128403 |
| 🖔 128404 | 🖖 128406 | 🖗 128407 | 🖘 128408 | 🖙 128409 | 🖚 128410 | 🖛 128411 | 🖜 128412 | 🖝 128413 | 🖞 128414 | 🖟 128415 | |
| 🖠 128416 | 🖡 128417 | 🖢 128418 | 🖣 128419 | 🖤 128420 | 🖥 128421 | 🖦 128422 | 🖧 128423 | 🖨 128424 | 🖩 128425 | 🖪 128426 | 🖫 128427 |
| 🖬 128428 | 🖭 128429 | 🖮 128430 | 🖯 128431 | 🖰 128432 | 🖱 128433 | 🖲 128434 | 🖳 128435 | 🖴 128436 | 🖵 128437 | 🖶 128438 | 🖷 128439 |
| 🖸 128440 | 🖹 128441 | 🖺 128442 | 🖻 128443 | 🖼 128444 | 🖽 128445 | 🖾 128446 | 🖿 128447 | 🗀 128448 | 🗁 128449 | 🗂 128450 | 🗃 128451 |
| 🗄 128452 | 🗅 128453 | 🗆 128454 | 🗇 128455 | 🗈 128456 | 🗉 128457 | 🗊 128458 | 🗋 128459 | 🗌 128460 | 🗍 128461 | 🗎 128462 | 🗏 128463 |
| 🗐 128464 | 🗑 128465 | 🗒 128466 | 🗓 128467 | 🗔 128468 | 🗕 128469 | 🗖 128470 | 🗗 128471 | 🗘 128472 | 🗙 128473 | 🗚 128474 | 🗛 128475 |
| 🗜 128476 | 🗝 128477 | 🗞 128478 | 🗟 128479 | 🗠 128480 | 🗡 128481 | 🗢 128482 | 🗣 128483 | 🗤 128484 | 🗥 128485 | 🗦 128486 | 🗧 128487 |
| 🗨 128488 | 🗩 128489 | 🗪 128490 | 🗫 128491 | 🗬 128492 | 🗭 128493 | 🗮 128494 | 🗯 128495 | 🗰 128496 | 🗱 128497 | 🗲 128498 | 🗳 128499 |
| 🗴 128500 | 🗵 128501 | 🗶 128502 | 🗷 128503 | 🗸 128504 | 🗹 128505 | 🗺 128506 | 🗻 128507 | 🗼 128508 | 🗽 128509 | 🗾 128510 | 🗿 128511 |
Unicode Characters vs. Symbol/WingDings Fonts
One of the primary benefits of using Unicode characters instead of Symbol and Wingdings fonts is that the Unicode characters will evidence upwardly correctly in drop-down lists and you tin can apply them in formulas and custom number formats. If you alter the font of a cell to wingdings, the formula may notwithstanding be readable in the Formula bar, but it is unreadable when editing the formula within the cell.
I've also had fewer compatibility issues when using common Unicode characters than when using special fonts.
Notes and References
✅, ❎ : Codes that are a specific color in a browser prove as black/white in Excel desktop and the color can be changed. But irresolute the color of these won't piece of work in Excel online or Google Sheets, which are browser-based apps.
🙂,🙃,🙄,🙅,🙆,🙇,🙈,🙉 : Some emojis render the same fashion they appear in texts on the iPhone when used within the Excel mobile app.
Need to convert HEX codes to Decimal? Use the HEX2DEC() or DEC2HEX() functions in Excel.
References
- Unicode Characters at wikipedia.org
- The UNICHAR Function at support.part.com - The official syntax page.
- RapidTables.com Unicode Character Symbols at rapidtables.com - A useful identify to browse the Unicode characters. Gives the HTML code and the Unicode.
- Alt Codes for Inserting Symbols at usefulshortcuts.com
- Conversion Utility for Using Special Symbols in CSS :before and :later
- History of Unicode at unicode.org
- Unicode Blocks at fileformat.info - lists blocks of symbols by category, including many of the newer symbols.
Source: https://www.vertex42.com/blog/help/excel-help/using-unicode-character-symbols-in-excel.html
Posted by: worthampardens.blogspot.com
0 Response to "What Is It Called When Characters Turn Into Special Characters In Excel?"
Post a Comment