Need a book? Engineering books recommendations...

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

RE: Excel Subscripts

[Subject Prev][Subject Next][Thread Prev][Thread Next]
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
Consulting Structural Engineers
32302 Camino Capistrano, #206
San Juan Capistrano, CA 92675
V (949) 248-8588•F (949) 209-2509

-----Original Message-----
From: seaint-seaosc(--nospam--at)mail-list.com [mailto:seaint-seaosc(--nospam--at)mail-list.com] On 
Behalf Of Gary L. Hodgson and Assoc. Sent: Friday, August 02, 2013 12:01 PM
To: seaint-seaosc(--nospam--at)mail-list.com
Subject: [SEAINT-SEAOSC] Excel Subscripts

List,

Do any of the resident Excel experts here know how to append a calculated 
number to an alphanumeric character as a subscript?  For example, a wind 
load is calculated for 3 different conditions so that there are 3 different 
 answers to be appended to W as a subscript.

thanks,
Gary

-------------------------------------------------------------------------
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>