In layman’s terms, Superscript and Subscript is a formatting used to convert the specific characters smaller and shift slightly above or slightly below the rest of the characters from the word.
In Google Sheets, this can be used to enter the copyright & trademark symbols such as @, RM, or *, or mathematical equations such as Sqm2, cm2, or chemical equations like H2O, CO2, and many more.
Until now, writing this blog, there is no built-in superscript and subscript functionality available in Google Sheets. But yes, still there are ways to add those using the below methods.
Superscript and Subscript CHAR() Template for Google Sheets
As most of you know CHAR() function provides the character values against the number values (ASCII codes) but many of you don’t know it also provides the Superscript and Subscript characters against the number values.
Yet it does not cover all the characters to be converted into superscript and subscript but it covers enough to write almost all the types of values which include superscript and subscript letters, symbols, or numbers.
You can download and copy the “Superscript and Subscript CHAR() Template”for your future reference.
Add Superscript and Subscript Using CHAR() Function
In Google Sheets, you can use the CHAR() function within the formula to write the values which include superscript and subscript letters, numbers, or symbols within that.
For example, you have to write the value “X2+2X2” and for the same, you have to write the formula including the CHAR() function within it.
Go to the cell, wherein you want to enter the value and write the formula including the CHAR() function.
=”x”&char(178)&”+2x”&char(8322)
How the Formula Works
In the formula above firstly, we entered the “x” value within a double quotation as our value starts with the “X” and to make it a normal text and after that, we used the “&” and sign to combine the next value and then we have entered the “CHAR” function with the value”178” which is the number value of superscript number “2” to make the “2” as superscript.
In the second step, we again entered the “&” and sign and then entered the “2X” characters within the double quotation to make it a normal text and then again entered the “&” sign to combine the further values and then “CHAR” function with the value “8332” which is the number value of subscript number “2” to make the “2” as subscript.
Add Superscript and Subscript Using Copy & Paste
This copy-and-paste is a very easy and simple way to write the Superscript and Subscript values. The only requirement for this is to save or copy the “Superscript and Subscript Template” for you. To do this follow the below steps.
- First, write the value as normal text.
- After that, go to the Superscript and Subscript template and double-click on the superscript or Subscript cell value that you want to copy and copy that value.
- Now, double-click in the cell and select the letter, character, number, or symbol which you want to replace with the copied Superscript or Subscript value and then press “Crtl+V” to paste the copied value.
- At this point, your selected number has been got replaced with the copied superscript value.
- Repeat the above steps but this time copy the subscript value “2” to replace the last number “2” of the value as subscript and paste it there.
Add Superscript and Subscript by Converting Online
The quick and fastest way to add Superscript and Subscript to Google Sheets is to convert them online and then copy and paste them into the sheets.
- First, open the “https://www.tinytextgenerator.com/superscript-text.html” website in your browser.
- Here, type or paste the value in the top input field, and it will be auto-converted into Superscript and Subscript simultaneously.
- Now, click the “Copy” button to copy the Superscript or Subscript value and paste it within the sheets.
In the above example, we entered “2” as a value, which was converted into Superscript and Subscript.
Other Links to Convert Value as Superscript and Subscript
Points to Remember
- No CHAR() values are in the Google Sheets to convert the fractional numbers into Superscript or Subscript.
- There is no shortcut or any built-in function available yet.