Hi Experts
I have found numerous examples of how to convert ranges/selections of cells to UpperCase, LowerCase & InitalCaps) by using a loop. Although it is much fast to have it done using the formula here:
[$G$10:$G$20] = [INDEX(UPPER($G$10:$G$20),)]
question:
How can I use the same formula...