Now, we can delete the original column of data so that we only have one column of data.

(to remove the copy outline you can hit the escape (Esc) key after you hit Enter) Select the output of the UPPER or LOWER function:.To remove the original list of data and keep the new list with either all upper case or lower case text we do this: As such, we need to still have the original list of data in order to have the new list. The problem with the above methods is that the output that we see that is now lower case or upper case is not actually text it is the output of the UPPER and LOWER functions in Excel. How to Make the New Text Actual Text instead of a Function In another cell, type =LOWER(A2) where A2 is the reference of the cell that contains the text you want to make lower case.In another cell, type =UPPER(A1) where A1 is the reference of the cell that contains the text you want to make upper case.How to Make the New Text Actual Text instead of a Function How to Quickly Make Text Upper Case in Excel How to Quickly Make Text Lower Case in Excel How to Quickly Make Text Upper Case in Excel I will show you how to change the case of text and also how to make the results of the functions we will use actual text instead of function/formula output.Īlso, check out our tutorial on how to capitalize first letter of every word in Excel. This allows you to change the case of text without having to manually type in the text. How to quickly change all text to upper case or lower case in Excel.

Make all text uppercase excel