![]() ![]() Copying and pasting from online repositories We can also insert superscript and subscript in Google Sheets by easily copying and pasting the value. In order to insert a subscript 2 in the chemical formula of water (H 2O), the input will be as follows: =“H”&CHAR(8322)&“O” Method 2: Copy and paste to insert superscript and subscript in Google Sheets We use the same formula but change the code for the corresponding subscript we want to insert. Add subscript in Google SheetsĪdding subscripts is no different from adding superscripts in Google Sheets. The base of the exponent is enclosed by quotation marks and also separated by “&”, as shown in the example below. Similarly, we can add multiple numbers as superscripts in Google Sheets using the CHAR function, separating each CHAR function by “&”. Paste the number in the CHAR formula as shown below.įor example, to insert superscript 5, for which the Unicode value is 8309, to base 10 we type in the following: =”10”&CHAR(8309).Copy the Unicode number for the character to add as superscript in Google Sheets.To add a superscript in Google Sheets using the CHAR function, follow the steps given below: Unicode table for subscripts Add superscript in Google Sheets We can use these codes to add the corresponding subscript or superscript in Google Sheets. ![]() You can find the list of all Unicode numbers for various characters including superscripts and subscripts on this website.īelow are the Unicode numbers for superscripts and subscripts for some common characters. All we have to do is find the corresponding code for the character we want to insert and use the CHAR function to display the character. It can be used to insert any character, such as an emoji or a currency symbol. The CHAR function uses an ASCII or Unicode value and returns the corresponding character. Method 1: Insert superscript and subscript in Google Sheets using the CHAR function Let us learn each of the methods to inset superscript and subscript in Google Sheets with examples. There are however a few workaround alternatives that you can use–all pretty easy but require a few steps. There is no inbuilt function (at least not yet) in Google Sheets by using a shortcut or formatting text. ![]() And there may have been times when you wanted to add superscript or subscript in Google Sheets, looked around for a while, found no solution, and so simply resorted to the second best option, which is, used the caret (^) for superscript and underscore (_) for the subscript. There may be instances where we want to insert superscript and subscript in Google Sheets. Step 2: Copy and paste the value into Google Sheets. Step 1: Convert the number to superscript in Google Sheets by using the shortcut Ctrl+. Here’s a quick guide on how to add a superscript in Google Sheets: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |