Kick off this New Year with 25% off on Kopyst Subscriptions! Use code NEWYEAR25
document-icon
How to capitalize all letters in Excel?
Created By Mitisha
|
7 months ago
|
document-icon Excel
|
5 Steps
Need to convert text in your Excel cells to all uppercase letters? This guide will show you how to easily capitalize entire words or sentences, ensuring data consistency and readability. You'll learn the primary method: using the UPPER function. Simply apply =UPPER(cell_reference) to the cell containing the text you want to convert, and Excel will instantly transform it into all caps. This function is incredibly useful for standardizing entries like names, product codes, or addresses. Master this quick Excel trick to clean up and unify your text data efficiently. It's Wednesday evening here in India, perfect for enhancing your spreadsheet prowess!
document-icon
How to capitalize all letters in Excel?
By Mitisha
|
document-icon Excel
|
5 Steps

1
Start Excel and open the workbook containing the text you want to capitalize.
2
Click on an empty "Cell" where you want the capitalized text to appear (e.g A3).
Merged Image action area
3
Type the following formula "=UPPER(A1)"
Replace A1 with the cell reference of the text you want to capitalize. This function converts all letters in the specified cell to uppercase.
Merged Image action area
4
Hit the "Enter" key on your keyboard.
5
The cell will now display the text from A1 in all uppercase letters.
Now, you have successfully capitalized all letters in your selected text in Excel!
Merged Image action area

Create your own professional guides

Start creating your own How-to guides and videos today!

App page Cta