how do I get " 1st" to look proper (superscript the "st")

  • Thread starter Thread starter frankg
  • Start date Start date
F

frankg

Here is my command in a cell (word wrapped for this posting) :

=CONCATENATE("1- Your January 1st,"," ",Sheet1!$I$9," ","mortgage
payment shall")


I want to make the "1st" look proper (superscript the "st"). Any
advice??? I tried to highlight and right click on the " st " in the
formula bar above but the format cell command was grayed out in the
pop up. If I go to the cell and highlight it, everything gets
superscripted when applied because everything gets highlighted (not
just the "1st" which is what I'm trying to do).

Thanks.
 
Hi Frankg

You sheet is protect that's why the format cell command is grayed out I think
 
Hi Frankg

You sheet is protect that's why the format cell command is grayed out I think
Click to expand...


Thanks for trying but no such luck. Oh well tomorrow is another day
<grin>.
 
AFAIK you can only format individual characters in a text
string, but you have described a formula.

You could dump a string into your cell with a formula in
code, and work out the start position of "st", which in
your example is 18

With Range("A1")
..Value = "1- Your January 1st " & Range("$I$9") & _
" mortgage payment shall"
..Characters(18, 2).Font.Superscript = True
End With

You may want to put your code in the "Worksheet_Change"
event of the Sheet containing Range("$I$9"), possibly use
a defined name for this range and compare with the Target.

Regards,
Sandy
-----Original Message-----
Here is my command in a cell (word wrapped for this posting) :

=CONCATENATE("1- Your January 1st,"," ",Sheet1!
Click to expand...
$I$9," ","mortgage payment shall")
 
Back
Top