I have an Excel spreadsheet of addresses. I want to change some words into lowercase (rather than the whole cell!). Those words are:
- TH to th (street name)
- 3RD to 3rd
- 2ND to 2nd
- 1ST to 1st
I know how to change the whole cell to lowercase or "Propercase" but I really need a function to change those improper uppercase to lowercase.
If you just have those three options: