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? Last edited by mintz; Aug 5th, 2015 at 05:37 PM.
This question generated 10 answers. To proceed to the answers, click here.