There are two ways in which we can accomplish this. But we usually need to display the superscript / subscript character with other text in the same cell. This will display only the symbol in the cell. 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. 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.
![how to make a superscript in google sheets how to make a superscript in google sheets](https://cdn.ablebits.com/_img-blog/google-sheets-change-case/change-case-google-docs.png)
![how to make a superscript in google sheets how to make a superscript in google sheets](https://sheetsformarketers.com/wp-content/uploads/2021/08/null.png)
The CHAR function returns the character corresponding to a given ASCII code. All you need to do is pass this code as a parameter to the CHAR function. You can make use of these ASCII codes to display the subscript or superscript symbol that you want to display. There are ASCII codes for subscript and superscript characters too.įor example, here’s a table of ASCII codes corresponding to all the different subscript Google Sheets compatible characters: Similarly, the ASCII code for the degree symbol character ( °) is 176. For example, the ASCII code for the letter A is 67. Method 1: Using ASCII Codes to Add Subscript and Superscript in Google SheetsĪSCII codes are numerical values that represent a particular character.
![how to make a superscript in google sheets how to make a superscript in google sheets](https://www.online-tech-tips.com/wp-content/uploads/2020/03/superscript-value.png)
#How to make a superscript in google sheets how to
Method 3: How to Superscript in Google Sheets With a Generator.Method 2: Using Unicode Symbols for Google Sheets Superscript and Subscript.Method 1: Using ASCII Codes to Add Subscript and Superscript in Google Sheets.