View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

You can't use subscripting in a cell with a formula.

You could use an event macro to build the text string and format it.
Assume your formula is


="Standard Deviation = " & STDEV(B1:B100) & " lbs/hr NOx"

Put something like this in the worksheet code module (right-click the
worksheet tab and choose View Code):

Private Sub Worksheet_Calculate()
Const STEXT = "Standard Deviation = $$ lbs/hr NOx"
Dim sStdDev As String

sStdDev = Format(Application.StDev(Range("B1:B100")), "0.000")
With Range("A1")
.Value = Application.Substitute(STEXT, "$$", sStdDev)
.Characters(Len(.Text), 1).Font.Subscript = True
End With
End Sub

Change your ranges to suit.


If you're not familiar with macros, see David McRitchie's "Getting
Started with Macros":

http://www.mvps.org/dmcritchie/excel/getstarted.htm


In article ,
METCO1 wrote:

I use subscripting in Excel for text cells, but would like to subscript in a
text string that includes numbers. For example, I need to subscript the "x"
in Standard Deviation = 0.125 lbs/hr NOx. Is there a way of doing this?