Use the Shift key while typing a letter to make it capital
Turn on Caps Lock to type all letters in uppercase
Use the formula `=UPPER(A1)` to convert text in cell A1 to capital letters
Copy the formula down to apply it to more cells
Use Flash Fill if Excel suggests the capitalized pattern
Use Find and Replace only if you need to change specific text manually
Use the Text to Columns or Power Query tools for larger text-cleaning tasks
Use `=PROPER(A1)` if you want each word to start with a capital letter
Use `=LOWER(A1)` if you need to convert text to lowercase instead