All of the superscript and subscript characters and CHAR function equivalents are available in this free template: Show
Superscript Google Sheets Template Open it and make your own copy from the menu: File > Make a copy Superscript In Google SheetsAt 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. Method 1: Copy Paste Unicode Characters
Here’s a list of superscripts, which you can copy: CharacterSuperscript0⁰1¹2²3³4⁴5⁵6⁶7⁷8⁸9⁹aᵃbᵇcᶜdͩeͤfᶠgᵍhͪiͥjʲkᵏlˡmͫnⁿoͦpᵖqNot available (why?)rͬsˢtͭuͧvͮwʷxˣyʸzᶻ+⁺–⁻=⁼(⁽)⁾Method 2: Create Superscripts in Google Sheets with the CHAR functionThe CHAR function converts a number into a character according to the current Unicode table. It’s a fun and amazing function. 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: Anyway, I’m getting carried away. You came here to learn how to add a superscript not a turkey. Back on the superscript two Graphemica page (see Method 1 above), copy the number part of the HTML Entity (Decimal), shown in red: Enter this formula in your Google Sheet:
With this in mind, here’s how you can create Einstein’s famous mass-energy formula:
(Quick aside: You can use the CHAR function embedded in other formulas, like any other function. For instance, here’s how to use the CHAR function to Create Custom Table Headers in Google Sheets Using Text Rotation.) Subscript In Google SheetsAdd subscripts in the same way you added superscripts to your Google Sheets. Method 1: Copy Paste Unicode CharactersSearch Graphemica and copy-paste the subscript into your Google Sheet, for example subscript two. Here are the subscript characters: Method 2: Subscript in Google Sheets Using the CHAR functionConsider the chemical makeup of water: two hydrogen atoms and one oxygen atom, written H₂O. In the same vein as the superscript example, you can use the CHAR function to create the subscript. Using Graphemica, search for the subscript you want and take the number from the HTML Entity (Decimal): Insert this into your CHAR function to create the subscript in Google Sheets:
Building on this, the full formula for water is:
Sugar Example Here’s a more complex chemical compound — sugar — which has the molecular formula C₁₂H₂₂O₁₁
Last Resort: Font SizeYou can also achieve a subscript effect by changing the font size of the subscript digits in your text. For example, setting the main text to font size 10 and the subscript to font size 6 will create a subscript effect. However, I wouldn’t advocate this method because it’s tedious and not robust. But if you’re in a pinch and need a unique subscript that you can’t find elsewhere, maybe it’ll help you out. >If I follow the logic... it is replacing the blank with That's very close! =FIND("^^",SUBSTITUTE(A1," ","^^",3)) Let's assume the cell entry is: asd abc 123 jkl Formulas evaluate the inner-most functions first then work backwards to the SUBSTITUTE(A1," ","^^",3) This is replacing the 3rd space in the string with ^^. So the string looks asd abc 123^^jkl This string is then passed to the FIND function: FIND("^^","asd abc 123^^jkl") FIND "finds" the substing ^^ starting at character position 12. So: A1 = asd abc 123 jkl =FIND("^^",SUBSTITUTE(A1," ","^^",3)) =12 The ^^ is just an arbitrary character (or string of characters) that is very -- news:[email protected]... Bagaimana cara membuat drop down list di Google sheet?Di Google Spreadsheet, buka spreadsheet. Pilih sel atau beberapa sel tempat Anda ingin membuat menu dropdown.. Masukkan “@.” Di Menu, pada bagian komponen, klik "Dropdown".. Di bagian atas, klik Sisipkan. Dropdown.. Klik Data. Validasi data. Tambahkan aturan .. Klik kanan sel. Dropdown.. Bagaimana cara untuk menambahkan sheet di Google Spreadsheet?Untuk membuat spreadsheet baru:. Buka layar utama Spreadsheet di sheets.google.com.. Klik Baru. . Ini akan membuat dan membuka spreadsheet baru Anda.. Fitur apa saja yang ada di Google sheet?Simak beberapa fitur unggulan Google Sheets berikut ini.. Kolaborasi bersama tim / pengguna lain. Google Sheets memungkinkan pengguna untuk melakukan kolaborasi bersama pengguna lain. ... . Terdapat riwayat revisi. ... . Melakukan editing secara real-time. ... . Integrasi dengan Google Forms. ... . Apa fungsi dari Google Sheet Google Spreadsheet?Spreadsheet Google mendukung formula sel yang biasa ditemukan di sebagian besar paket spreadsheet desktop. Formula tersebut dapat digunakan untuk membuat fungsi yang melakukan pengolahan data dan kalkulasi string dan angka.
|