Numerical values for subscript and superscript alphabets are also available, but not for all of them.įor your convenience, I have created a Google Sheet containing lists of ASCII codes along with the subscript/superscript character they represent. In the same way, there are numerical values corresponding to subscript and superscript numbers 0 to 9, as well as mathematical symbols like (), +, – and =. So if you type the following CHAR function into a cell and press the Enter/Return key, you will get the letter ‘A’ as a result of the function. There are numerical values (called ASCII codes) corresponding to each character.įor example, the decimal value for the character A is 67. It gives the character value corresponding to a given decimal value. The CHAR() function is one of the in-built functions of Google sheets. Here are three ways you can use superscripts and subscripts in Google Sheets. 3 Ways to Get Subscript and Superscript in Google Sheets And it’s understandable since Google Sheets was built to work with numbers and is not a word processor.īut a lot of people do need to display data that comes in the form of fractions or formulae in spreadsheets too (this is also one of the common queries I get from people).įortunately, there are ways to add subscripts and superscript in Google Sheets. Using subscripts and superscripts is fairly easy on Google Docs, but this feature has not yet been implemented on Google Sheets. It is also used to represent temperatures in degrees. Superscripts, on the other hand, are often used to raise a number or variable to a certain power (eg: x 2).
You may also need to use subscripts in mathematics, when you are trying to denote different versions of the same variable or to refer to a member of a sequence, for example – a 0, a 1, a 2…
You might need subscripts while writing chemical formulae or notation. When and Why We Need Superscript and Subscript in Google Sheets Subscripts are positioned slightly lower than the normal text, while superscripts are positioned slightly higher than the normal text.
When and Why We Need Superscript and Subscript in Google Sheets.
0 kommentar(er)
