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
