zinehwa.blogg.se

It asserts that two quantities or expressions have the same value. In the same vein as the superscript example, you can use the CHAR function to create the subscript.

Method 2: Subscript in Google Sheets Using the CHAR functionĬonsider the chemical makeup of water: two hydrogen atoms and one oxygen atom, written H₂O. Here are the subscript characters: Character Search Graphemica and copy-paste the subscript into your Google Sheet, for example subscript two. (Quick aside: You can use the CHAR function embedded in other formulas, like any other function.įor instance, here’s how to use the CHAR function to Create Custom Table Headers in Google Sheets Using Text Rotation.) Subscript In Google SheetsĪdd subscripts in the same way you added superscripts to your Google Sheets. You came here to learn how to add a superscript not a turkey.īack on the superscript two Graphemica page (see Method 1 above), copy the number part of the HTML Entity (Decimal), shown in red: It lets you add weird and wonderful pictures to your Google Sheets using formulas, such as this Christmas tree (from my newsletter) or this turkey:Īnyway, I’m getting carried away. The CHAR function converts a number into a character according to the current Unicode table. Method 2: Create Superscripts in Google Sheets with the CHAR function

Here’s a list of superscripts, which you can copy: Character To get multiple superscripts next to each other, just copy them multiple times e.g.Paste into your Google Sheet in the formula bar.Type in the symbol you want, using words instead of numbers e.g.Go to the website Graphemica, which is a great site to search for unicode characters.Open it and make your own copy from the menu: File > Make a copy Superscript In Google SheetsĪt the moment there is no built-in option to add a superscript in Google Sheets (or subscript), so we have to be creative to achieve the effect. Superscript And Subscript Google Sheets TemplateĪll of the superscript and subscript characters and CHAR function equivalents are available in this free template: In this tutorial, you’ll learn how to add a subscript or superscript in Google Sheets.