How to Change Lowercase to Uppercase in Excel?

Use the UPPER function: `=UPPER(A1)`

Enter the formula in a new cell

Copy the formula down for other cells

Copy the results

Paste Special as Values to replace the original text

Use Flash Fill if the pattern is simple

Use Power Query to transform text to uppercase

Use VBA macro to convert selected cells to uppercase

Suggested for You

Trending Today