ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Font size smaller and bigger in a formula (https://www.excelbanter.com/excel-worksheet-functions/87905-font-size-smaller-bigger-formula.html)

Gary T

Font size smaller and bigger in a formula
 
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

Duke Carey

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



All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com