If you came from a technical field such as science and engineering, you will be very familiar with the mathematical symbols of subscripts and superscripts. In fact, we often use a shorthand when typing subscripts and superscripts:
Fortunately, in these 3 simple Google Sheets tutorials, we will show you how to easily add subscript and superscript in Google Sheets so that you do not need to use extra symbols in your mathematical formulae or scientific notations.
The CHAR function returns a character corresponding to a specific ASCII code. We have attached below the ASCII codes for each subscript and superscript in Google Sheets.
To use this formula, follow these steps:
For example, we want to write E=mc^2 with the two as a superscript.
In our example, we want to add a superscript 2 to replace the regular 2 in our equation. Our ASCII code is 178.
So that you do not have to look up your ASCII code for the CHAR function, we have attached a list of common codes at the end of this Method 1 tutorial.
In our example, we need to include other characters with the superscript. To do so, we include the string in quotes and attach it to the CHAR function with an "&" symbol.
We would type ="E=mc"&CHAR(178)
In addition to using the CHAR function, another simple method for adding a subscript or superscript to your Google Sheets is to use Unicode symbols. You can use one of many online tools to generate a Unicode symbol and then paste it into your Google Sheet, such as Superscript Generator ― LingoJam or Subscript Generator ― LingoJam.
We have also included the Unicode symbols under this paragraph, and you can easily copy and paste the Unicode symbols directly into your own spreadsheet.
Superscripts -> X⁺⁻⁰¹²³⁴⁵⁶⁷⁸⁹
Subscripts -> x₊₋₀₁₂₃₄₅₆₇₈₉
This method of using Unicode symbols is best when you only have a few equations. It can become tedious to copy paste each Unicode symbol into your Google Sheet. Also, Unicode still does not have Unicode characters for the whole alphabet in superscript and subscript form, so you might want to think twice if you want to add whole words to your Google Sheets with it.
The third method involves creating a superscript or subscript in a word processor, then transferring the symbols to your Google Sheet. For this article, we will use a Google Doc.
After typing your statistical data or notation in Google Docs, select the number that you want to superscript.
Next, click the Format menu, and hover over the Text option.
From the menu, select the Superscript option.
You could also choose Subscript if you need that option.
Your text will look like this:
You can now simply copy and paste your new symbol or the whole string into your Google Sheets spreadsheet. Voila!
Now that you have 3 methods to add superscript and subscript numbers into Google Sheets, you should have no trouble with mathematical formulas or chemical formulae. Your superscript and subscript characters will make your spreadsheet stand out as more professional and exact compared to using other workaround notations.
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.
.png)
