Converting lowercase to uppercase in Excel is a common data cleaning task. Excel provides three main methods: the UPPER function for formula-based conversion, Flash Fill for quick single-column transformations, and Power Query for batch processing across large datasets.
Method 1: UPPER Function
The UPPER function converts all text in a cell to uppercase. In a blank column next to your data, enter: =UPPER(A2). Copy the formula down for all rows. The result column shows uppercase versions of the original text. To replace the original data with the uppercase values: copy the formula column, paste as Values Only into the original column, then delete the formula column.
Method 2: Flash Fill
Flash Fill automatically detects patterns and fills data accordingly. Type the uppercase version of your first cell in the adjacent column. Press Ctrl+E (Windows) or Cmd+E (Mac). Excel applies the same transformation to all remaining rows. This method is faster than formulas for straightforward case conversions on single columns.
Method 3: Convert Case Online
For converting text case without using Excel formulas, Format Pilot’s text case converter handles uppercase conversion instantly. Copy your text from Excel, paste it into the converter, click UPPERCASE, and paste the result back. This is particularly useful when working with text from multiple sources that you want to clean before importing into Excel.
Frequently Asked Questions
What is the Excel formula to convert text to uppercase?
=UPPER(cell_reference) — for example =UPPER(A2) converts the text in cell A2 to all uppercase. Use =LOWER(A2) for all lowercase and =PROPER(A2) for title case (first letter of each word capitalized).