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

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

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