ExcelBanter - How do I type Cl 2 ( Chlorine) or H 2 O ( water) in a cell ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I type Cl 2 ( Chlorine) or H 2 O ( water) in a cell ? (https://www.excelbanter.com/excel-discussion-misc-queries/263209-how-do-i-type-cl-2-chlorine-h-2-o-water-cell.html)

Gopi Nathan

How do I type Cl 2 ( Chlorine) or H 2 O ( water) in a cell ?

T. Valko

How do I type Cl 2 ( Chlorine) or H 2 O ( water) in a cell ?

Type the text.

Use your mouse and select the characters you want to subscript.
Right clickFormat CellsSubscriptOK
Then hit Enter

If you do this a lot (I used to!) there is a free add-in here that makes it
a bit easier:

http://spreadsheetpage.com/index.php...atting_add_in/

--
Biff
Microsoft Excel MVP

"Gopi Nathan" <Gopi wrote in message
...

bala_vb

Yes it is possible to have superscript and subscript in excel.

Step1: After typing the H20, just select only 2 and right click
step2: format cells
step3: In effects you will find superscript and subscript options

all the best

Gord Dibben

How do I type Cl 2 ( Chlorine) or H 2 O ( water) in a cell ?

Try this add-in.

http://spectrum.troy.edu/~cking/ChemFormat/

Scroll down to Excel section for download.

Gord Dibben MS Excel MVP

On Wed, 5 May 2010 17:03:01 -0700, Gopi Nathan <Gopi
wrote:

All times are GMT +1. The time now is 10:42 AM.