This article will discuss converting the text in any case to upper case in excel. Also, we will look into removing the formula from the column.
To convert any case to upper case in excel, we can use the formula UPPER under text formulas.
STEP1: Type =UPPER(position of the text) in the ƒx box and press return
![](https://managementbliss.com/wp-content/uploads/2022/01/Screenshot-2022-01-09-at-1.40.07-PM-1024x684.jpg)
Text of one cell will be converted to upper case.
![](https://managementbliss.com/wp-content/uploads/2022/01/Screenshot-2022-01-09-at-1.50.01-PM-1024x815.jpg)
STEP2: To convert the column to upper case just Drag and Release.
![](https://managementbliss.com/wp-content/uploads/2022/01/Screenshot-2022-01-09-at-1.53.38-PM-1024x889.jpg)
IN CASE YOU WANT TO REMOVE FORMULA
STEP1: Select the text, do a right-click and press Copy option.
![](https://managementbliss.com/wp-content/uploads/2022/01/Screenshot-2022-01-09-at-2.21.32-PM-1024x875.jpg)
STEP2: Again, select the text do right-click and press Paste Special option.
![](https://managementbliss.com/wp-content/uploads/2022/01/Screenshot-2022-01-09-at-2.26.18-PM-1024x748.jpg)
STEP3: Further select Values option.
![](https://managementbliss.com/wp-content/uploads/2022/01/Screenshot-2022-01-09-at-2.24.52-PM-1024x747.jpg)
Done.
![](https://managementbliss.com/wp-content/uploads/2022/01/Screenshot-2022-01-09-at-2.28.18-PM-1024x758.jpg)
I hope this article helped you convert text to uppercase and remove the formula in Excel. Good Luck!!!