How to Insert Symbols in Word, Excel and Google Docs

01

The one Word shortcut worth knowing

Type a character's hexadecimal code point, then press Alt and X together. Word replaces the digits with the character. Type 2665 then Alt+X and you get a heart suit.

It needs no numeric keypad, which makes it the only reliable method on a laptop. Pressing Alt+X again with the cursor after a character reverses it and shows you the code, so it doubles as a way to identify what you are looking at.

02

The Symbol dialog and autocorrect

Insert then Symbol opens a browsable grid with a search box and a subset filter. It also shows any existing shortcut for the character you select.

For a symbol you use constantly, add it to autocorrect. Map a short trigger such as (deg) to the degree sign once, and it appears as you type from then on.

03

Excel is different

Alt+X does not work in Excel. Use Insert then Symbol, or the UNICHAR formula, which takes a decimal code point and returns the character. UNICHAR(9829) gives a heart suit.

UNICODE does the reverse, returning the code point of the first character in a cell. That pairing is useful for auditing a column that contains characters you did not expect.

04

Symbols in spreadsheet data

Keep decorative characters out of any column you sort, filter, join or look up. A styled letter is not the letter it resembles, so VLOOKUP and exact matches quietly fail against it.

Symbols are fine in headers, notes and display columns. Keep the machine-readable value in a separate plain column.

✦

If a lookup fails on data that looks identical, check for invisible characters and styled letters before you check your formula.

05

Google Docs and Sheets

Google Docs has Insert then Special characters, with search and a draw-to-find panel that is genuinely useful when you do not know the name. It also supports substitution rules, which behave like Word's autocorrect.

Google Sheets has no Symbol dialog, but it supports the same UNICHAR and UNICODE formulas as Excel, and it defaults to UTF-8 so pasted symbols survive better than in a Windows CSV import.

06

Exporting to PDF

A PDF embeds a subset of each font containing only the characters it believes are used. A symbol drawn from a fallback font sometimes fails to embed and arrives as a blank box in the exported file.

Always check the exported PDF rather than the editor. If a character drops, switch it to one from a font you have explicitly applied.

07

Copy the symbols discussed in this guide

This guide explains the topic. Use currency symbols for the main copyable set, compare it with unit symbols, and browse punctuation symbols for another useful angle. Each collection includes searchable Unicode names and HTML references.