VBA to superscript a part of a cell
 

Your testing was more thorough than mine Rick

I see what you mean after more testing.



Gord

On Thu, 15 Apr 2010 15:43:28 -0400, "Rick Rothstein"
wrote:

If the text in the cell has one of your ordinals with an actual word before
the day number having that ordinal, then nothing will be superscripted. For
example, if the text were one of these, then nothing gets superscripted...

"Current start date is October 21st this year."

"August 1st begins the month."

"Hard start date: Jan 3rd."