Excel - Convert text to lowercase
Apparently, many versions ago, Excel had the function to change a highlighted cell to lower/upper/proper case text.
I've only known Excel to change text case via a formula/macro, but you need a source cell and a destination cell.
The caller is adament the function to change the text case without a formula is still in Excel and wants us to find the 'button'. I was wondering if there actually is (or ever has been) a function do change text case? As the caller doesn't want to sift through this large spreadsheet finding the particular cells that need changing text case.