This will open the page containing unicodes for all the subscript and superscript symbols.Scroll down and click on the “ Superscript and Subscript Letters” category.Click on “ See all” to see all the categories available.If you’re using the unicode-table website, follow the steps shown below:
One easy method of how to add superscript in Google Sheets is to simply Google it with the prefix “ Subscript” or “ superscript” as shown below, and copy-paste the symbol that appears.Īnother easy method of how to do subscripts in google sheets is to visit websites like or to obtain the unicode symbol you need. There are numerous websites available online from where you can fetch the unicode symbol for your required subscript/superscript symbol. Unlike ASCII codes, unicodes don’t usually need to be converted and can directly be copy-pasted anywhere. They internally represent special symbols by specific codes, and can be copied and pasted to display the character they represent quite easily.Ĭlick here to see how you can use unicodes to display different kinds of checkmarks. This is the easiest and quickest way to add superscripts and subscripts in Google Sheets. Method 2: Using Unicode Symbols for Google Sheets Superscript and Subscript Notice we used the number 8322 this time because it represents the superscript of 2. Similarly, to display the notation H2O, we would use the following formula: =”H”&CHAR(8322)&”O”
We passed the number 178 to the CHAR function because it is the ASCII code that represents subscript character 2. So if you want to display the notation x2, simply use the ampersand (&) to append the CHAR function to the text “x” as follows: =”x”&CHAR(178) The second way to display a subscript or superscript with other text in a cell, is by directly appending the CHAR function to the text. You can then adjust the font size as needed.
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.
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.