When converting entire ranges to upper case, you can use an array formula for efficiency. Enter the formula, and then hit Ctrl + Shift + Enter this way, you dont have to apply the function to each ...