Degree symbol
U+00B0 · °- Excel=UNICHAR(176)
Enter =UNICHAR(176) in a cell to return °.
Excel 2013 or later. The English function name is shown; localized Excel may use another name. Paste values if you need text without a formula. Source ↗
SYMBOLS ON YOUR PLATFORM
Excel symbol methods.
Use UNICHAR with a decimal Unicode value in a cell. The result is text, not a mathematical operator. Formula names may be localized.
Copyright symbol
U+00A9 · ©- Excel=UNICHAR(169)
Enter =UNICHAR(169) in a cell to return ©.
Excel 2013 or later. The English function name is shown; localized Excel may use another name. Paste values if you need text without a formula. Source ↗
Registered trademark symbol
U+00AE · ®- Excel=UNICHAR(174)
Enter =UNICHAR(174) in a cell to return ®.
Excel 2013 or later. The English function name is shown; localized Excel may use another name. Paste values if you need text without a formula. Source ↗
Trademark symbol
U+2122 · ™- Excel=UNICHAR(8482)
Enter =UNICHAR(8482) in a cell to return ™.
Excel 2013 or later. The English function name is shown; localized Excel may use another name. Paste values if you need text without a formula. Source ↗
Check mark
U+2713 · ✓- Excel=UNICHAR(10003)
Enter =UNICHAR(10003) in a cell to return ✓.
Excel 2013 or later. The English function name is shown; localized Excel may use another name. Paste values if you need text without a formula. Source ↗
Heavy check mark
U+2714 ·- Excel=UNICHAR(10004)
Enter =UNICHAR(10004) in a cell to return ✔.
Excel 2013 or later. The English function name is shown; localized Excel may use another name. Paste values if you need text without a formula. Source ↗
Right arrow
U+2192 · →- Excel=UNICHAR(8594)
Enter =UNICHAR(8594) in a cell to return →.
Excel 2013 or later. The English function name is shown; localized Excel may use another name. Paste values if you need text without a formula. Source ↗
Left arrow
U+2190 · ←- Excel=UNICHAR(8592)
Enter =UNICHAR(8592) in a cell to return ←.
Excel 2013 or later. The English function name is shown; localized Excel may use another name. Paste values if you need text without a formula. Source ↗
Up arrow
U+2191 · ↑- Excel=UNICHAR(8593)
Enter =UNICHAR(8593) in a cell to return ↑.
Excel 2013 or later. The English function name is shown; localized Excel may use another name. Paste values if you need text without a formula. Source ↗
Down arrow
U+2193 · ↓- Excel=UNICHAR(8595)
Enter =UNICHAR(8595) in a cell to return ↓.
Excel 2013 or later. The English function name is shown; localized Excel may use another name. Paste values if you need text without a formula. Source ↗
Left right arrow
U+2194 · ↔- Excel=UNICHAR(8596)
Enter =UNICHAR(8596) in a cell to return ↔.
Excel 2013 or later. The English function name is shown; localized Excel may use another name. Paste values if you need text without a formula. Source ↗
Black star
U+2605 · ★- Excel=UNICHAR(9733)
Enter =UNICHAR(9733) in a cell to return ★.
Excel 2013 or later. The English function name is shown; localized Excel may use another name. Paste values if you need text without a formula. Source ↗