ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Subscripts (https://www.excelbanter.com/excel-discussion-misc-queries/194913-subscripts.html)

James

Subscripts
 
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

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

"James" wrote:

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.


Bernard Liengme

Subscripts
 
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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"James" wrote in message
...
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 Silverton[_3_]

Subscripts
 
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
http://www.rsc.org/education/teacher...et/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

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

"Bernard Liengme" wrote:

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"James" wrote in message
...
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.




Gord Dibben

Subscripts
 
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

On Tue, 15 Jul 2008 15:40:22 -0300, "Bernard Liengme"
wrote:

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

Subscripts
 
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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


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


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



All times are GMT +1. The time now is 06:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com