Excel does not have a direct button for changing case, but you can easily transform text using simple functions. This guide shows you how to convert text to uppercase, lowercase, or proper case.
Faça com IASelect a blank cell
Click on an empty cell next to the text you want to change.
Enter the case function
Type =UPPER(A1), =LOWER(A1), or =PROPER(A1) into the cell, replacing A1 with your target cell reference.
Apply the formula
Press Enter, then drag the fill handle down to apply the change to the rest of your data.
Paste as values
Copy the new cells, right-click the original column, and select 'Paste Values' to replace the old text.
=UPPER(cell) / =LOWER(cell) / =PROPER(cell)Yes, you can use Flash Fill (Ctrl + E) by typing the desired format in the adjacent column and letting Excel detect the pattern.