Change Case in Excel Archives

Applying Automatic Uppercase in Excel VBA – 2 Examples

Aug 12, 2024

The Excel VBA UCase Function VBA Ucase function is a built-in function used to convert text to uppercase. It takes strings as input and converts ...

Applying Automatic Uppercase in Excel VBA – 2 Examples

How to Use VBA in Excel to Capitalize All Letters (4 Examples)

Aug 4, 2024

How to Open the VBA Macro Editor in Excel You will need the Developer tab at the top of the worksheet. Click on the Developer tab and select ...

How to Use VBA in Excel to Capitalize All Letters (4 Examples)

How to Convert Text to Title Case in Excel (4 Methods)

Jul 24, 2024

Dataset Overview We'll use the data set below to demonstrate the methods. Method 1 - Using the PROPER Function The PROPER function is a ...

How to Convert Text to Title Case in Excel (4 Methods)

Using Excel VBA to Capitalize the First Letter of Each Word – 3 Examples

Aug 3, 2024

The dataset contains employee names and their designation. To capitalize the first letter of each word: Example 1 - Using the VBA ...

Using Excel VBA to Capitalize the First Letter of Each Word – 3 Examples

How to Change Case for Entire Column in Excel: 7 Methods

Jul 5, 2024

Method 1 - Excel PROPER Function to Change Case for Entire Column Steps: Create a new column (i.e. Modified Location Column). Select a cell ...

How to Change Case for Entire Column in Excel: 7 Methods

Change Upper Case to Lower Case in Excel: 6 Easy Methods

Jun 4, 2024

Method 1 - Applying LOWER Function Type the following formula in cell E5. =LOWER(D5) Press ENTER. Therefore, you will see the ...

Change Upper Case to Lower Case in Excel: 6 Easy Methods

How to Stop Auto Capitalization in Excel (with Quick Steps)

Nov 11, 2025

Auto Capitalization is often a handy feature of Excel. But sometimes it can be a frustrating thing as Excel does Auto Capitalization by default. In ...

How to Stop Auto Capitalization in Excel (with Quick Steps)

How to Make First Letter of Sentence Capital in Excel (4 Methods)

Jul 11, 2024

Method 1 - Combining UPPER, RIGHT, LEFT, and LEN Functions to Make the First Letter of a Sentence Capitalized in Excel Steps: Go to Cell C5 and ...

How to Make First Letter of Sentence Capital in Excel (4 Methods)

How to Capitalize All Letters Without Formula in Excel (4 Methods)

Jun 23, 2024

Method 1 - Using the Flash Fill feature to Capitalize All Letters We have a dataset of different Student names and IDs. We want to put the names in ...

How to Capitalize All Letters Without Formula in Excel (4 Methods)

How to Change Case in Excel Sheet (8 Quick Methods)

Nov 11, 2025

While working in Microsoft Excel we might find different cases like lowercase, and uppercase in different cells. Sometimes you will find upper and ...

How to Change Case in Excel Sheet (8 Quick Methods)

Excel Change to Proper Case Without Formula (6 Easy Ways)

Nov 11, 2025

Looking for ways to know how you can change to proper case without formula in Excel? Then, this is the right place for you. Here, you will find 6 ...

Excel Change to Proper Case Without Formula (6 Easy Ways)

How to Change Sentence Case in Excel (6 Ideal Examples)

Nov 11, 2025

When you are working with addresses or customer/employee names, then you may need to change the sentence case into other cases. This article shows ...

How to Change Sentence Case in Excel (6 Ideal Examples)

How to Change Lowercase to Uppercase with Formula in Excel (3 Ways)

Nov 11, 2025

Suppose you have created an Excel spreadsheet but unfortunately used lowercase for all the cells containing texts you needed to make uppercase. In ...

How to Change Lowercase to Uppercase with Formula in Excel (3 Ways)

How to Capitalize First Letter of Each Word in Excel (4 Ways)

Jun 24, 2024

To capitalize the first letter of each word, we are going to use the following dataset, which contains some employee names in column B but in the ...

How to Capitalize First Letter of Each Word in Excel (4 Ways)

How to Change Lowercase to Uppercase in Excel Without Formula (5 Methods)

May 15, 2024

Here, we have a simple dataset containing two columns. Let's change the lowercase text in the left column to uppercase in the empty right column. ...