View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default Font size smaller and bigger in a formula

No - you can't apply character formatting to portions of a formula or its
results. Just to constants



"Gary T" wrote:

Hello

Is it possible to have font sizes smaller and bigger within the one cell, as
a result of the formula within this cell?

i.e. is there a command such as "=FONTSIZE("Charge: ",2)&"Not applicable"

which would make the text "Charge: " two font sizes larger than the text
"Not Applicable"???

Many Thanks