All you need to do is pass this code as a parameter to the CHAR function. The CHAR function returns the character corresponding to a given ASCII code.
Syntax for the function is as follows: =CHAR( number) The symbol returned depends on the character set of your computer, but this is usually the same on all computers. To display your required superscript / subscript symbol, simply pass the ASCII code for it to the CHAR function, as follows: Here, number is the ASCII code corresponding to the character you want to return.įor your convenience, we have created a Google Sheets workbook with ASCII codes corresponding to all the superscript and subscript symbols you’ll need.Ĭlick on the appropriate tab to find the ASCII codes you need. This will display only the symbol in the cell.
But we usually need to display the superscript / subscript character with other text in the same cell. There are two ways in which we can accomplish this. #How to make a superscript in google sheets how to.
0 kommentar(er)
