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.