Excel does not have Word’s Change Case button, but the UPPER function can convert text to uppercase without retyping it. Use a helper column, then paste the converted results as values if you want to replace the original text.
Convert text to uppercase
- Suppose the original text is in cell A2.
- Click an empty cell such as B2.
- Enter =UPPER(A2) and press Enter.
- Fill the formula down for the remaining rows.
Replace the original text if needed
Select the converted cells and copy them. Then use Paste Special > Values over the desired destination. Pasting values is important because otherwise the cells continue to contain formulas referring to the original text.
Other case functions can help
LOWER converts text to lowercase, while PROPER capitalizes the first letter of words. PROPER is convenient but may produce undesirable capitalization for acronyms, names, and words with intentional mixed case.
Formulas do not modify the source cell
UPPER returns a converted version of the text in another cell. That makes it easy to inspect the result before replacing your original data.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.