PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO SUBSCRIPT TEXT IN GOOGLE SHEETS

INTRODUCTION

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.

 

WHEN IS SUBSCRIPT USED IN GOOGLE SHEETS ?

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

 

For example

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….

 

WAYS TO SUBSCRIPT TEXT IN GOOGLE SHEETS

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 :

  • GOOGLE
  • UNICODE SYMBOLS
  • USING UNICHAR FUNCTION
  • ADDONS
  • REFERENCE SUBSCRIPT CHARACTERS READY TO BE USED.

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.

 

SUBSCRIPT TEXT IN EXCEL USING GOOGLE.COM

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

  • Visit https://www.google.com. [ You can click here ].
  • Type in the searchbox ” 2 number subscript”.
  • Google will find its best result and the excerpt containing the SUBSCRIPTED 2 will appear somewhere.
  • The following screen will appear. [ The results may vary as per your location, but it’ll be on the same lines. ]
CLICK SUBSCRIPT AND CLICK OK
  • Look at the picture above.
  • Copy any of the subscripted 2 and paste it in  your sheet but this process needs you to be a bit smart regarding the use of the subscript 2 from the google results.

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.

COPY THE SUBSCRIPTED 2 AS SHOWN IN THE RESULTS
  • After copying the subscripted 2, Paste it by pressing CTRL+V  in the Google sheets, wherever you want to use it.

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.

RESULT OF SUBSCRIPTING USING GOOGLE.COM OPTION.

SUBSCRIPT TEXT IN GOOGLE SHEETS BY COPYING UNICODE SYMBOLS

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 [0067] 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

and https://www.fileformat.info.

STEPS TO SUBSCRIPT BY COPYING THE UNICODE SYMBOL FROM THE UNICODE CHART:

UNICODE.ORG HOME SCREEN FOR CHARACTER CHARTS
  • Press CTRL+F on the browser , it’ll open the browser search.
  • Enter Subscripts.
  • It’ll take you directly to the subscripts table text.
  • Click the link. [Direct link is given here https://unicode.org/charts/PDF/U2070.pdf]
CLICK LINK FOR SUPERSCRIPTS AND SUBSCRIPTS
  • After clicking the link, a pdf will open.
SCROLL DOWN TO OPEN THE DESIRED TABLE OF SUBSCRIPTS
  • Simply find your required subscript.
  • Select the subscript.
  • Press CTRL+C or Right Click > COPY.
COPY THE DESIRED SUBSCRIPT FROM THE TABLE
  • Paste it in the Google Sheets wherever required.
  • The following picture shows the usage.
  • The  subscripted 2 has been pasted after copying it from the table. The second line shows the concat formula to check if the subscript is working fine or not. We can see that the subscript was concatenated successfully.
RESULT SHOWING THE SUBSCRIPTED 2 USING UNICODE.ORG

STEPS TO SUBSCRIPT BY COPYING THE UNICODE SYMBOL FROM THE UNICODE INFORMATION PROVIDING WEBSITES :

  • Go to https://www.compart.com/en/unicode
  • As we reach the page of the link mentioned above, we’ll find the following screen.
  • Simply enter the requirement in the SEARCH BOX at the top of the page.
  • Enter “subscript” in the SEARCH BOX and press ENTER.
TYPE THE SEARCH AND CLICK OK.ALL THE RESULT WILL BE ENLISTED
  • Click the result of our requirement i.e. Subscript of 2.
  • As we click the result, the following screen follows.
SELECT THE SUBSCRIPT NUMBER AND PASTE IT IN GOOGLE SHEETS
  • Simply copy the symbol by selecting it.
  • Paste it anywhere in the google sheets.
RESULT OF ADDING NUMBER 2 AS SUBSCRIPT COPYING FROM COMPART.COM

STEPS TO SUBSCRIPT BY COPYING THE UNICODE SYMBOL FROM THE UNICODE INFORMATION PROVIDING WEBSITES :

  • Go to https://www.fileformat.info/
  • As we reach the page of the link mentioned above, we’ll find the following screen.
  • Enter “subscript 2” in the SEARCH BOX.
  • Click SEARCH.
OPEN FILEFORMAT.INFO , ENTER THE SEARCH CONTENT AND CLICK SEARCH
  • It’ll enlist all the results of available subscripts.
  • Click the result we want i.e. Subscript of 2.
FONT SETTINGS BUTTON LOCATION
  • After clicking the search , the following screen will appear containing the SUBSCRIPT 2 with different encodings.
  • We’ll use UTF – 8.
SELECT THE SUBSCRIPT WITH UTF-8 ENCODING
  • Simply copy the subscript 2, by selecting it and pressing CTRL+C or Right Click > Copy.
  • Paste it anywhere in the google sheets.
  • The following example shows the pasted subscript 2.
  • We tried it using the concat function.
  • The subscript is working fine.
FONT SETTINGS BUTTON LOCATION

SUBSCRIPT TEXT IN GOOGLE SHEETS USING UNICHAR FUNCTION

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:

  • Select the cell , where we want to want to get the subscript 2 
  • Use the function = UNICHAR( CODE or CELL ADDRESS CONTAINING THE CODE).
  • For Subscript 2 , the UNICODE IS 8322 (IN DECIMAL NUMBER SYSTEM )
  • Enter the formula as =UNICHAR(8322)
  • Click Enter.
  • The result will appear as a subscripted 2.
  • The result is shown in the picture below.
OUTPUT OF THE SUPERSCRIPTING USING 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.

SUBSCRIPT UNICODE REFERENCE TABLE

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.

SYMBOL DESCRIPTION HEX CODE DECIMAL CODE
SUBSCRIPT ZERO 2080 8320
SUBSCRIPT ONE 2081 8321
SUBSCRIPT TWO 2082 8322
SUBSCRIPT THREE 2083 8323
SUBSCRIPT FOUR 2084 8324
SUBSCRIPT FIVE 2085 8325
SUBSCRIPT SIX 2086 8326
SUBSCRIPTS EVEN 2087 8327
SUBSCRIPT EIGHT 2088 8328
SUBSCRIPT NINE 2089 8329
SUBSCRIPT PLUS 208A 8330
SUBSCRIPT MINUS 208B 8331
SUBSCRIPT EQUAL 208C 8332
SUBSCRIPT LEFT PARENTHESIS 208D 8333
SUBSCRIPT RIGHT PARENTHESIS 208E 8334
SUBSCRIPT SMALL LETTER A 2090 8336
SUBSCRIPT SMALL LETTER E 2091 8337
SUBSCRIPT SMALL LETTER O 2092 8338
SUBSCRIPT SMALL LETTER X 2093 8339
SUBSCRIPT LATIN SMALL LETTER SCHWA 2094 8340
SUBSCRIPT SMALL LETTER H 2095 8341
SUBSCRIPT SMALL LETTER K 2096 8342
SUBSCRIPT SMALL LETTER L 2097 8343
SUBSCRIPT SMALL LETTER M 2098 8344
SUBSCRIPT SMALL LETTER N 2099 8345
SUBSCRIPT SMALL LETTER P 209A 8346
SUBSCRIPT SMALL LETTER S 209B 8347
SUBSCRIPT SMALL LETTER T 209C 8348


OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]