Need a book? Engineering books recommendations...

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

Re: Excel Subscripts

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Would the concatenate command work? If you had Wind in cell A1 and _3 in cell B1, concatenate(A1,B1) would give you Wind_3.
If cell B1 had 3, concatenate(A1,"_",B1) would give you the same result.

On 8/2/2013 11:00 AM, Gary L. Hodgson and Assoc. wrote:

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.


*Drew Morris, PE*| /Project Engineer/
BBFM Engineers, Inc. <>
510 L Street, Suite 200 | Anchorage, Alaska 99501
Ph: (907)274-2236 | Fax: (907)274-2520 | Web:

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

The email messages sent to the list will be saved in an archive on the World Wide Web.
These archives are located at:

To contact the list owner, send your message to:

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.