How To Capitalize All Letters In Excel?

Use the formula `=UPPER(A1)`

Replace `A1` with the cell containing the text

Press Enter

Copy the formula down for other cells if needed

Copy the results

Paste Special as Values to replace the original text with capitalized text