CARA MERUBAH HURUF KECIL KE BESAR DI EXCEL

Have you ever worked in Microsoft Excel and found the need to change the case of text from upper case to lower case or vice versa? Well, worry no more as we bring you the solution to this problem. In this article, we will guide you on how to change text case in Excel and also provide answers to common questions related to this topic.

How To Change Text Case In Excel

Before we proceed, it’s important to note that there are three types of case in text: uppercase, lowercase, and proper case. Uppercase is when all letters are in capital, lowercase is when all letters are in small, and proper case is when the first letter of each word is in capital.

Now, let’s see how to change text case in Excel:

Changing Text to Uppercase

1. Select the cell containing the text you want to change.
2. Click on the “Home” tab on the excel ribbon.
3. Click on the “Font” group.
4. Click on the “Uppercase” button.

Alternatively, you can use the UPPER function to change text to uppercase. The syntax for this function is:

=UPPER(text)

Where “text” is the cell containing the text you want to change to uppercase. Simply type the formula in an empty cell and use the cell reference of the text cell as the argument.

Changing Text to Lowercase

1. Select the cell containing the text you want to change.
2. Click on the “Home” tab on the excel ribbon.
3. Click on the “Font” group.
4. Click on the “Lowercase” button.

Alternatively, you can use the LOWER function to change text to lowercase. The syntax for this function is:

=LOWER(text)

Where “text” is the cell containing the text you want to change to lowercase. Simply type the formula in an empty cell and use the cell reference of the text cell as the argument.

Changing Text to Proper Case

1. Select the cell containing the text you want to change.
2. Click on the “Home” tab on the excel ribbon.
3. Click on the “Font” group.
4. Click on the “Proper Case” button.

Alternatively, you can use the PROPER function to change text to proper case. The syntax for this function is:

=PROPER(text)

Where “text” is the cell containing the text you want to change to proper case. Simply type the formula in an empty cell and use the cell reference of the text cell as the argument.

FAQs

Can I use conditional formatting to change text case?

No, you cannot use conditional formatting to change text case. Conditional formatting is used to format cells based on specific conditions, while changing text case involves changing the actual text in the cell.

Is there a way to change the case of multiple cells at once?

Yes, you can change the case of multiple cells at once using the “Fill” feature. Here’s how:

1. Select the cells containing the text you want to change.
2. Type the case you want in an empty cell and press “Enter”.
3. Copy the cell containing the desired case.
4. Select the cells you want to change.
5. Right-click on the selection and choose “Paste Special”.
6. Check the “Values” box and click “OK”.

This method will replace the original text with the new case while preserving other formatting like font, size, and color.

Video Tutorial

For a more visual guide on how to change text case in Excel, check out this video tutorial:

With these tips, changing text case in Excel has never been easier. Whether you need to capitalize names, all caps a title or make an announcement stand out, using these inbuilt features in Excel will always come in handy.