You must have seen the subscripted text or a number such as Log represented with a base or the valency in chemistry.
Subscript is the process of putting a smaller version of any letter or symbol lowered from the normal level of text input. For Example H2O. 2 is in the subscript format.
The most common example of a subscript is found in the Mathematics such as showing the LOG BASE or in Chemistry while writing the chemical formulae such as Oxygen as O2, Sulphuric acid as H2SO4.
We also need this while showing the NUMBER BASE whether its binary or octal or hexadecimal etc.
GOOGLE SHEETS DOESN’T HAVE ANY DIRECT OPTION OR SHORTCUT FOR SUBSCRIPT TEXT.
SUBSCRIPT is mostly needed while we are working with Mathematics or Chemistry.
We require them frequently while working with chemical formulae or Logarithms or writing down any series in Mathematics where we give the numbers as subscript like
H2O is the chemical formula of water.
Log210 and Log10100 are the logarithm expressions with different base.
Subscripts are also needed when we show any series etc. such as a1, a2, a3….
As we don’t have any direct option for subscript format in Google Sheets, but there are a few ways by which we can add subscripted text in Google Sheets.
Here is the list of available options.
The ways available are :
Let us discuss all the ways one by one in detail.
We’ll take an example of inserting the SUBSCRIPT FOR 2 [ NUMBER ] using the different options available for inserting the Subscript in Google Sheets.
When we are preparing a report at our work, our task is to get the things done within the time limits with ultimate accuracy.
This method is fastest method of inserting a subscript in Google Sheets , but we need to be cautious when using this method.
THE REQUIREMENT FOR THIS METHOD IS TO HAVE AN ACCESS TO THE INTERNET because we are going to use the GOOGLE.COM website for the search.
STEPS TO ADD SUBSCRIPT SYMBOL IN GOOGLE SHEETS USING GOOGLE.COM
USE THE RESULTS WHICH ARE OFFERED BY ANY WEBSITE CONCERNED WITH THE UNICODES. [ We’ll discuss it in detail later in this article ].
In this case, we’ll copy the use the first result and copy the subscripted 2 as shown in the picture below.
The following picture shows the usage.
The example shown in the picture contains the subscripted 2 pasted by copying it from the google result.
We have tested the subscripted 2 by concatenating it with a text which is visible in the formula field and we can see that the brought symbol is working fine.
This method is the second fastest but safest method to use a SUBSCRIPT within seconds if you have access to INTERNET.
A LITTLE BACKGROUND ABOUT UNICODE:
As per OXFORD DICTIONARY , UNICODE IS
an international encoding standard for use with different languages and scripts, by which each letter, digit, or symbol is assigned a unique numeric value that applies across different platforms and programs
This is the latest encoding standard which is being used on different platforms such as operating systems, web , email etc.
In simple words, UNICODE SYSTEM is the set of codes where we have given a particular code for every character or symbol, for example
A means 0041 [0065 in decimal ] in the UNICODE character system.
B means 0042 [0066 in decimal ], C means 0043  and so on.
Similarly there are codes for the numbers for example,
1 is 0031 [ 0049 in decimal ] and so on.
*THE CODES MENTIONED ABOVE ARE IN HEXADECIMAL NUMBER SYSTEM. THE DECIMAL EQUIVALENT IS SHOWN IN THE BRACKETS ].
As we already discussed that UNIQUE CODE or UNICODE for A is 0041. Now let us try to find out the UNICODE for small A i.e. “a”.
The UNICODE for “a” is 0061 [ 0097 in decimal]. So we can see that a small letter and a capital letters have a unique and different identification for the computing systems which makes these characters unique.
So is the concept of the UNICODE SYSTEM.
Another simple meaning to the UNICODE SYSTEM is that this code will be same across various platforms even if it is on web or software, which is the fact of our need for the time.
In this method, we’ll be taking help of other websites providing the help for the UNICODE NUMBER system or the UNICODE OFFICIAL WEBSITE.
OFFICIAL WEBSITE OF UNICODE IS https://unicode.org
which contains all the Charts of many languages and character sets.
The site shows all the important updates about the UNICODE.
For our purpose of SUBSCRIPTS we are particularly interested in https://unicode.org/charts/PDF/U2070.pdf
[This is the chart for SUBSCRIPTS and SUPERSCRIPTS containing all the codes available.]
And good supporting websites which may prove helpful to us are https://www.compart.com
THIS METHOD IS BEST IF WE DON’T HAVE ACCESS TO THE INTERNET. IF WE CAN REMEMBER THE CODE, THIS IS THE FASTEST METHOD.
UNICHAR FUNCTION RETURNS THE CHARACTER REPRESENTED BY THE GIVEN CODE.
STEPS TO SUBSCRIPT BY USING THE UNICHAR FUNCTION:
ANY OF THE THREE MENTIONED SITES CAN BE USED TO KNOW THE UNICODE OF ANY SUBSCRIPT. NOT ALL CHARACTERS HAVE THE SUBSCRIPT UNICODE.
The table has been created in Google Sheets using the UNICHAR Function.
The same is pasted here and it can be used directly in our GOOGLE SHEET.
Copy the subscript under the SYMBOL COLUMN and paste it directly.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE