How to Add Superscript and Subscript in Google Sheets [2024]

| | April 7, 2024
Be known by your own web domain (en)

Adding superscript and subscript in Google Sheets can be quite useful for various purposes such as mathematical equations, chemical formulas, footnotes, and more. 

While Google Sheets doesn't have dedicated buttons for superscript and subscript like some other word processing software, you can still achieve these effects using a couple of different methods.

In this tutorial, you'll learn how to add superscript and subscript in Google Sheets using the CHAR function.

At the end, you'll also get the list of important formulas along with ASCII Codes that you can just copy and paste on your Google Sheet for your use.

Let's get started.

Note: This article contains affiliate links. When you click an affiliate link and make a purchase, we get a small compensation at no cost to you. See our Privacy Policy and Disclaimer for more info.

Superscript and Subscript in Google Sheets

Adding Superscript in Google Sheets

The CHAR function in Google Sheets is a powerful tool that allows users to manipulate and work with character values in their spreadsheets. 

This function is particularly useful when dealing with textual data and can help streamline various tasks such as data manipulation, formatting, and text-based calculations.

When it comes to using the CHAR function in Google Sheets, it's essential to understand its primary purpose. 

The function is designed to return the character specified by the ASCII code, providing users with the ability to generate specific characters based on their numerical codes.

Using this function we can easily add superscripts as well as subscripts in our sheets.

Thus, in this tutorial, we will use the Char function and show you how to input the formula correctly to generate the right superscripts and subscripts.

Creating Superscripts Using the CHAR function

First you need open Google Sheets from your browser by visiting the link given below.

Google Sheets - https://docs.google.com/spreadsheets/u/0/ 

Now, let's say you want to write the famous Einstein formula, E = mc2 in your sheet, where 2 is the superscript. To add 2 as superscript in Google Sheets, you need to know the proper ASCII code for the number 2.

The ASCII Code for the number 2 is 178.

So, to replace the regular 2 as superscript in the formula E = mc2, we will use the ASCII code 178.

Below you can see that I have entered the formula ="E=mc"&CHAR(178) in the cell to produce the result we wanted.

Please note that all the text characters are required to be entered inside the double quotation mark ("").

Superscript in Google Sheets

In Google Sheet, if you want to superscript text or numbers, you need to perform the following steps:

Step 1: Click on a cell in your Google Sheet
Step 2: Enter the formula “=CHAR(numerical value)”
Step 3: Press Enter

Thus, in just three steps, you should now have a superscript character in the cell.

Below is the ASCII Code for numbers from 0 to 9 so that you can easily create superscripts in Google Sheets.

Number

ASCII Code for Superscripts

0

8304

1

185

2

178

3

179

4

8308

5

8309

6

8310

7

8311

8

8312

9

8313

Let's see some more example where we will try to input some mathematical expressions containing superscripts. 

Example 1: Click on a cell in your Google Sheet and enter the formula =char(8308) and press the Enter button on your keyboard. The result would be superscript 4 as shown below.

In the above table, you can see that the ASCII Code for 4 is 8308 that is why on using the formula =char(8308) in Google Sheets, it generated number 4 as superscript.

Superscript with ASCII Code

Example 2: In this example, we will generate 7⁵ using the char function. In the above table, you can see that the ASCII Code for number 5 is 8309.

So, we will use the formula =7&char(8309) and press the Enter button on your keyboard. The result would be 7 to the power 5 (7⁵) as shown below.

7 to the power 5

Example 3: Below is an example of producing the mathematical expression a3 + b3. To produce this result, I have entered this formula ="a"&char(179)&"+b"&char(179).

Maths Superscripts in Google Sheets

Example 4: In this example, we will try to produce the formula (a + b)2 = a2 + 2ab + b2, where 2 is the superscript.

To generate this formula with proper superscript in Google Sheet, click on a cell and enter this formula ="(a + b)"&char(178)&"= a"&char(178)&" + 2ab + b"&char(178).

Below, you can see that I have successfully produced the expression (a + b)2 = a2 + 2ab + b2 using the formula mentioned above. 

Maths Expression in Google Sheets

By using the CHAR function and proper ASCII Code, and following the steps as covered above, now, you would be able to add superscript in Google Sheets easily. 

In the next section, we will see how to add subscripts in Google Sheets.

Adding Subscript in Google Sheets

Using the same Char function and specific ASCII Code we can easily add subscripts in Google Sheets.

Below are some ASCII Codes for creating subscripts in Google Sheets using the Char function.

Number

ASCII Code for Subscripts

0

8320

1

8321

2

8322

3

8323

4

8324

5

8325

6

8326

7

8327

8

8328

9

8329

Example 1: Click on a cell in your Google Sheet. Now, enter the formula =char(8326) and press the Enter button. The result would be subscript 6 as shown below.

Subscript in Google Sheets

Example 2: In this example, we will generate H2 using the char function. In the above table, you can see that the ASCII Code for number 2 is 8322.

So, we will use the formula ="H"&char(8322) and press the Enter button. The result would be H₂ as shown below.

Adding Subscript in Google Sheets

Example 3: Below is an example of producing the chemical formula of water which is H2O. To produce this result, we will entered this formula ="H"&char(8322)&"O".

H2O Formula in Google Sheets

Example 4: In this example, we will try to produce the formula of washing soda Na₂CO₃, where the numbers 2 and 3 are the subscripts.

To generate this formula with proper subscript in Google Sheet, click on a cell and enter this formula ="Na"&char(8322)&"CO"&char(8323as shown below.

Google Sheets Subscripts

I hope now you have a clear understanding of inserting both superscripts and subscripts in your sheets.

By following the simple steps covered in this tutorial, you can easily add superscript and subscript text in your Google Sheets document, enhancing the visual appeal and clarity of your data.

Wrapping Up

By incorporating superscript and subscript in Google Sheets, you can significantly enhance the presentation and readability of your data.

Whether you're noting chemical formulas, mathematical notations, or footnotes, these formatting options offer a versatile way to convey information effectively within your spreadsheets.

I hope you found the tutorial on how to add superscripts and subscripts in Google Sheets helpful. If you've liked it please share it with your friends on social media.

For more useful tips and tutorials, please check out the below mentioned resources from our blog.

Photo of author

Deepak Choudhary

Deepak Choudhary is the founder of Technicalwall.com. He is a Blogger and an Affiliate Marketing Expert. He publishes useful articles for newbie bloggers related to the following topics - Affiliate Marketing, Email Marketing, Software Reviews, Software Tutorials, Blogging, WordPress, SEO, Passive Income, and more.