This article will discuss converting the text in any case to lower case in excel. Also, we will look into removing the formula from all the cells in the column.
To convert any case to lower case in excel, we can use the formula LOWER under text formulas.
How to Change Case in Excel to Lower Case
STEP1: Type =LOWER(position of the text) in the ƒx box and press return
Text of one cell will be converted to lower case.
STEP2: To convert the entire column to lower case just Drag and Release.
IN CASE YOU WANT TO REMOVE FORMULA
STEP1: Select the text, do a right-click and press Copy option.
STEP2: Again, select the text do right-click and press Paste Special option.
STEP3: Further select Values option.
DONE.
I hope this article helped you convert text to lowercase and remove the formula in Excel. Good Luck!!!