Sites such as Graphemica have thousands of characters (alphabets and symbols) which can be copied and pasted into Google Sheets. Copying and pasting from online repositories You can also insert superscript and subscript in Google Sheets by simply 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 the value
#Subscript in google sheets for mac code#
We use the same formula but change the code for the corresponding subscript we want to insert. Add superscript in Google SheetsĪdding subscript is no different from adding superscript. 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 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.To add superscript in Google Sheets using the CHAR function, follow the steps given below: 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 using the CHAR function Method 3: Insert superscript and subscript in Google Sheets using third-party sites.Copying and pasting from online repositories.
0 kommentar(er)
