how to change case in excel

Hi,

I'm Sneha and I'd be happy to help you out with your question.

To change the case of text in Microsoft Excel, you can use the "Text Functions".

Here are a few options:

UPPER Function: Converts text to uppercase. Syntax: =UPPER(text)

LOWER Function: Converts text to lowercase. Syntax: =LOWER(text)

PROPER Function: Capitalizes the first letter of each word. Syntax: =PROPER(text)

Example:

A1 = "change case in MS Excel"

B1 = =UPPER(A1)

C1 = =LOWER(A1)

D1 = =PROPER(A1)

After applying the above formulas, the result in B1 will be "CHANGE CASE IN MS EXCEL", C1 will be "change case in ms excel", and D1 will be "Change Case In MS Excel".

If you have any other questions or need assistance with anything, please don't hesitate to let me know. I'm here to help to the best of my ability.

Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

Best Regards, Sneha

HI ColleenAK,

You can try the following function:

• UPPER: Converts text to uppercase. Syntax: =UPPER(text)
• LOWER: Converts text to lowercase. Syntax: =LOWER(text)
• PROPER: Converts the first letter of each word in text to uppercase. Syntax: =PROPER(text)