• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to use subscript while entering chemical names of materials

V

VDS

Member
@Dear All,

I want to write the chemical names of some materials Just like Water (H2O), Sulphuric Acid (H2SO4), Carbon Di Oxide (CO2) etc. Here, the numeric provided in the bracket will be written as Subscrpt. However, for repeated number of numerals, how the subscript can be applied in a single stretch ? What I want when chemical name is typed, the numeral should be displayed as subscript in order to avoid Format cells again and again.

H20 H2O WATER
H2S04 H2SO4 SULPHURIC ACID
CO2 CO2 CABON DI OXIDE
NH4CI NH4Cl AMONIUM CHLORIDE
C4H6O6 C4H6O6 Tartaric Acid




VDS
 
@Debraj,

My excel version is different 2003. There is no equation editor with my excel package.

Is there any options avaiable ?


VDS
 
@Narayan Sir : Thanks for reply. I will go through it
@Somendra, How it can be done on multiple entries ?


VDS
 
@VDS

Sorry I was busy in some family function. Could not saw the post.

To do this: follow the steps:

1. Enter any Formula or information like H2SO4.
2. Select 2 in edit mode.
3. Go to format cell dialogue box by selecting it from right click menu or keyboard shortcut Ctrl+1.
4. Select Subscript as show below and press enter.
5. Repeat same for 4.
subscript.jpg
Regards,
 
Well! i was searching on this issue also, now i've got the solution. Thanks VDS for starting this post here.
Somendra Misra your tips ware really helpful. You make me easy to use subscript, it's amazing. :D
 
  • Like
Reactions: VDS
You must log in or register to reply here.
Back
Top