Excel: "39Th Ann Thomas St" How to make it 39th but keep the Thomas?

I have this sample string for a street address: 39Th Ann Thomas St Ann Thomas 39Th St Ann Thomas St 39Th How to convert the 39Th to lower-case (th) but keep the Thomas in PROPER-case? (Th) The __th position is dynamic, could be anywhere in the string, in the beginning or middle or end I want to use SUBSTITUTE(A1,"XTh","Xth") where X is any digit/number - what do I need to write instead of the X so that the SUBSTITUTE replaces "Th" with "th" only when it comes after a digit/number?

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of August 05, 2015.

For more resources for Microsoft Excel