On Apr 16, 8:04*am, Dave Peterson wrote:
You *may want to try John Walkenbach's addin:http://j-walk.com/ss/excel/files/supersub.htm

Mikhail Bogorad wrote:

hi
i have a report that populates some text descriptions in cells range
B2:B15. So sometimes text has a date, for example "... October
1st...". What i want is to superscript letters "st" every time it
finds "1st".

Has anyone ever encountered this problem before?

Thanks

--

Dave Peterson

Thanks guys, i'll test your suggestions and let you know. In my report
it can only be "1st" no "2nd" or "3rd" but thanks anyways.