Subscripts

[James]

I am typing in lots of chemical formulas, and wanted to know if there is a
faster way to subscript my numbers.

I found the following Add-in and it works ok but, I wanted to see if there
was a way to blanket a row of chemical formulas in my spreadsheet to have all
numbers be in subscript.
http://j-walk.com/ss/excel/files/supersub.htm

Thanks for any help.

 

[James]

Left one thing out, I would like all the subscript to have a font of 10.

 

[Bernard Liengme]

James:
I used the add-in from
http://spectrum.troy.edu/~cking/ChemFormat/
for about 10 years before I retired as a chem prof.
You will love it
best wishes

 

[James Silverton]

James wrote on Tue, 15 Jul 2008 09:27:03 -0700:

I found the following Add-in and it works ok but, I wanted to
see if there was a way to blanket a row of chemical formulas
in my spreadsheet to have all numbers be in subscript.
http://j-walk.com/ss/excel/files/supersub.htm

I have an MS Word macro to make all the numbers subscript in a chemical
formula. The formula is typed with standard size numbers and the macro
is then run (from a button in my case). However, I have never tried to
modify it for Excel. There are free fonts available for chemistry from
the Royal Society of Chemistry
www.rsc.org/education/teachers/learnnet/RSCfont.htm
and

http://www.scs-intl.com (Chemistry serif) (Chemistry Sans-serif)




--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not

 

[James]

So very cool, I only wish I had this when I was in college. Thanks a bunch

 

[Gord Dibben]

Thank you Bernard

I remembered seeing a posting for an add-in similar or maybe same.

Went through google back a half dozen years but not find it.


Gord

 

[James Silverton]

Bernard wrote on Tue, 15 Jul 2008 15:40:22 -0300:

James:
I used the add-in from
http://spectrum.troy.edu/~cking/ChemFormat/
for about 10 years before I retired as a chem prof.
You will love it
best wishes

Two James's here! However, thanks very much Bernard, the add-ins look
very useful and I hope James the Other gets a lot of use of it. For
myself, I am retired too

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not