Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

RE: Excel Subscripts

[Subject Prev][Subject Next][Thread Prev][Thread Next]
If you're fairly comfortable with VBA, you could create a routine that 
takes the input from the cells you want, concatenates it into a complete 
string, puts it into your output cell, and formats the subscript as Bill 
describes.  You'd then have to make the function "volatile", and give it 
some trigger to run, like when you change one of the input cells.  It's 
doable, but quite a bit of work, just to get a subscript.  If you can live 
the appearance of a simple concatenation formula in the cell, that would be 
 a whole lot easier.

-- Joel

the structural alliance
Joel Adair, PE, LEED AP
Principal

-----Original Message-----
From: seaint-seaosc(--nospam--at)mail-list.com [mailto:seaint-seaosc(--nospam--at)mail-list.com] On 
Behalf Of T. William (Bill) Allen, S.E. Sent: Friday, August 02, 2013 2:36 
PM To: seaint-seaosc(--nospam--at)mail-list.com
Subject: RE: [SEAINT-SEAOSC] Excel Subscripts

Drew's got the right point about concatenation, but the subscript part is a 
 bit more difficult. You would probably have to run a macro something like:

With ActiveCell.Characters(Start:=x, Length:=y).Font
        .Subscript = True
End With

Where "x" is the starting position of the character you want to make 
subscript and "y" is the number of characters you want to subscript.

Have fun with that!

To me, it would be easier just to highlight the characters you wanted to 
subscript and hit the subscript function. I only use subscripts for names, 
not results.

T. William (Bill) Allen, S.E. (CA #2607) University of Southern California, 
 M.S.C.E., 1983 University of Texas at El Paso, B.S.C.E., 1977

ALLEN DESIGNS

Truncated 674 characters in the previous message to save energy.

-------------------------------------------------------------------------
Post your message to the list by sending it to: 
   SEAINT-SEAOSC(--nospam--at)mail-list.com.

The email messages sent to the list will be saved in an archive on the World Wide Web.
These archives are located at:
    http://archive.mail-list.com/SEAINT-SEAOSC

To contact the list owner, send your message to:
   SEAINT-SEAOSC-list-owner(--nospam--at)mail-list.com.

Sponsored By: Pacific Structural & Forensic Engineers Group, Inc. (PSFEG)

To unsubscribe, switch to/from digest, get on/off vacation, or change your email address, click here.
<http://cgi.mail-list.com/u?ln=seaint-seaosc&nm=seaintma%40euken.net>