subscript letters on google docs for mac

It contains some numeric values in Column B and E.įurther, there are formulas in columns A and D (use formulas, not the Formulatext as per the screenshot). Method # 1 – Using Formulasįirst, create a Google Sheets file like the one (I have my sheet shared at the end of this post) in the image below. Here in this tutorial, we are using the CHAR function which will bring the character representation of a given decimal value. Yes! Then only we will get 10 digits from 0 to 9 each for Subscript and Superscript in Google Sheets. To get subscript and superscript numbers in Google Sheets there are 20 numbers to convert to Characters/Strings. How to Get Subscript and Superscript Numbers in Google Sheets

But it is sadly missing in Google Sheets now. Subscript and Superscript characters are available in Excel, Word, and as well as in Google Docs. But when we want to create complex formats, we depend on Spreadsheets. Normally we can use document writers for most of the occasions. and for that, document writers such as Word and Docs were enough. I was personally using such ornamented characters while preparing test certificates of the test conducted on soil/gravel/aggregates etc. to make our Spreadsheet more readable and correct. We require this format on certain occasions like for entering chemical formulas, measurement units, etc. Simply speaking, Subscripts and Superscripts are a type of character ornamentation as these are the characters printed above the line or below the line respectively. Understand Subscript and Superscript and Its Use in Google Sheets Included tips to insert a few fractions (characters) in Google Sheets.Inserting of Superscript characters/alphabets in Google Sheets (except character “q” which is not available).

How to insert Subscript numbers in Google Sheets.

How to insert Superscript numbers in Google Sheets.

In concise, in this tutorial, you can learn But you will get one sample sheet at the end of this post which contains some superscript alphabets too. Subscript and Superscript character ornamentation, with numbers.Īnyway, I am not discussing in detail how to Superscript characters in Google Sheets here. Here you can learn how to get both these features, i.e. It’s a missing feature in Google Spreadsheet. Let’s learn how to use Subscript and Superscript numbers and also some letters in Google Sheets.

Subscript letters on google docs for mac