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?
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: