Use the UPPER function: `=UPPER(A1)`
Use the LOWER function: `=LOWER(A1)`
Use the PROPER function: `=PROPER(A1)`
Enter the formula in a new column
Fill the formula down for all rows
Copy the results
Paste Special as Values to replace the original text
Use Find and Replace to correct specific inconsistent words
Use Flash Fill to standardize repeated text patterns
Use TRIM to remove extra spaces: `=TRIM(A1)`
Use CLEAN to remove nonprinting characters: `=CLEAN(A1)`