Home / Computer / How to Easily Change Case Text in Microsoft Excel 2019-2010 – iSumsoft

How to Easily Change Case Text in Microsoft Excel 2019-2010 – iSumsoft

Change Text Case in Excel

This post will show you how to use the UPPER, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case.

Convert text case in Excel

The easiest way to change from small to capital letters in Excel is by using the UPPER function. In contrast, use the LOWER function to convert all letters in a text string to lowercase. The PROPER function is used to convert the uppercase texts to proper case, which capitalizes only the first letter in each word.

How to Convert Text to Proper Case

Insert a temporary column next to the column that contains the text you want to convert, if it is needed.

Entering the PROPER Function

In cell B1, type =PROPER(A1), then press Enter.

Enter Proper function

This formula converts the name in cell A1 from uppercase to proper case. To convert the text to lowercase, type =LOWER(A1) instead. Use =UPPER(A1) in cases where you need to convert text to uppercase, replacing A1 with the appropriate cell reference.

Using Flash Fill

Fill down the formula in the new column. The quickest way to do this is by selecting cell B1, and then double-clicking the small black square that appears in the lower-right corner of the cell.

Using Flash filling


>> Source Link

Check Also

How to remove Adobe Creative Cloud on a computer

To install various desktop applications for Adobe products such as Adobe PhotoShop CC, Adobe Premiere …

%d bloggers like this: