Insert Symbols and Special Characters in Excel

image_pdf

You can use the Symbol dialog box to enter symbols and characters that are not on your keyboard. Some examples are ASCII characters, Unicode characters, and other special characters, such as a paragraph mark, copyright symbol, and trademark symbol.

To insert symbol, execute the following steps.

1) On the worksheet, click where you want to insert the symbol.

2) On the Insert tab, click Symbol.

The 'Symbol' dialog box appears.

Click the arrow in the Font box, and then click the font that you want in the list.

Note: - Different fonts provide different symbols. For example, if you want to insert check marks or bullets, you may be able to find them in the list of symbols supplied for the Wingdings font.

3) Click the symbol that you want to insert, and then click Insert. You can also double-click the symbol and then click Close.

If the Subset box is available, click a subcategory.

The Subset list is available for expanded fonts, such as Arial or Times New Roman, and provides an extended list of language characters, punctuation, and mathematical symbols, such as:

  1. Greek characters (Basic Greek)
  2. Russian characters (Cyrillic)
  3. An assortment of punctuation and bullets (General Punctuation)
  4. Various currency symbols (Currency Symbols)

Note: - For more symbols in each category, you might want to install the Arial Unicode MS font on http://fontsgeek.com/fonts/Arial-Unicode-MS-Regular

1) from box: To insert Unicode character and ASCII character.

a) Unicode (hex)

The set of characters is limited if you select something other than Unicode in the from box. For example, if you select a local code page rather than Unicode, you see a correspondingly reduced set of characters in the Symbol dialog box.

b) ASCII Character

The most widely accepted code is called the American Standard Code for Information Interchange (ASCII). The ASCII code associates an integer value for each symbol in the character set, such as letters, digits, punctuation marks, special characters, and control characters.

Character Code

When you click a Unicode character in the Symbol dialog box, its character code appears in the Character code box. The name displayed to the left of the Character code box is the official character name in the Unicode 3.0 standard. If you already know the character code, you can type it directly into the Character code box to find the Unicode character.

Special character

This includes things like the copyright symbol, math signs, and arrows.

  1. On the Insert menu, click Symbol.
  2. Click the Special Characters tab.
  3. In the Character list, select the character that you want to insert, and then click Insert

Note: – To repeat a symbol on your worksheet — for example, to create a bulleted list — you can drag the fill handle 2 across the cells that you want to fill.

3,403 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>