Special characters

CODE()English version CODE(), returns the numeric code of the first character in a text string.

IN EXCEL easily format the font to display Superscript (x2) and subscript (Al2O3) characters. This can be done by highlighting part of the text in the cell and using the dialog box Format cells / Font (CTRL+SHIFT+F) to apply the desired font formatting. But this approach does not work if the cell is not a value but a formula. And yet, in some cases, there is a solution.

If You need to display the latitude or longitude in the format 56°54'31" (56 degrees 54 minutes 31 seconds) this is an example for You.

In MS WORD special characters (end of paragraph, line break, etc.) are easy to find using standard search (CTRL+F), because they correspond to the special symbol combinations (^v ^l). In standard EXCEL search the use of such combinations is not provided, but the situation can get out another way.

Sometimes you want the cell to display nonstandard characters, for example, an arrow or a watch. This can easily be done using embedded fonts.

When pasting the EXCEL sheet the text from WORD that contains several paragraphs and tab characters, the text is inserted into several cells. Let us consider why this is so.

let us Consider the insertion into a cell of text from WORD that contains several paragraphs and tab characters.

To display 0 instead of the symbol ? (crossed out 0) use the custom format # ##0,00,-# ##0,00,?.

If a cell contains a long formula, with the help ofthe creed line Break (ALT+ENTER) convenient to display it in multiple lines in the box formula bar.  

Knowing the decimal value of the character code, you can enter this character using the key combination ALT+code. Of course, any character can be entered through a command Insert/ Text/ Symbol but sometimes, for example, if you enter a custom format using Format cells, but this command is not available.