Change the case of text (2024)

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2013 Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile More...Less

Unlike Microsoft Word, Microsoft Excel doesn't have a Change Case button for changing capitalization. However, you can use the UPPER, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case. Functions are just built-in formulas that are designed to accomplish specific tasks—in this case, converting text case.

How to Change Case

In the example below, the PROPER function is used to convert the uppercase names in column A to proper case, which capitalizes only the first letter in each name.

  1. First, insert a temporary column next to the column that contains the text you want to convert. In this case, we’ve added a new column (B) to the right of the Customer Name column.

    Change the case of text (1)

    In cell B2, type =PROPER(A2), then press Enter.

    Change the case of text (2)

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

  2. Now, fill down the formula in the new column. The quickest way to do this is by selecting cell B2, and then double-clicking the small black square that appears in the lower-right corner of the cell.
    Change the case of text (3)

    Tip:If your data is in an Excel table, a calculated column is automatically created with values filled down for you when you enter the formula.

  3. At this point, the values in the new column (B) should be selected. Press CTRL+C to copy them to the Clipboard.

    Change the case of text (4)

    Right-click cell A2, click Paste, and then click Values. This step enables you to paste just the names and not the underlying formulas, which you don’t need to keep.

  4. You can then delete column (B), since it is no longer needed.

Need more help?

You can always ask an expert in the Excel Tech Communityor get support inCommunities.

See Also

Use AutoFill and Flash Fill

Need more help?

Want more options?

Discover Community

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Change the case of text (2024)

FAQs

How do you change the case of text easily? ›

To use a keyboard shortcut to change between lowercase, UPPERCASE, and Capitalize Each Word, select the text and then press fn+ SHIFT + F3 until the style you want is applied.

What are the 5 text change cases? ›

To change the text case, find the “Change Case” button on your Home bar as shown below: You will find some options termed as Sentence Case, Lower Case, Upper Case, Toggle Case, Capitalize each word.

What is the formula for changing text case? ›

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

Can you change the text case in Excel? ›

Unlike Microsoft Word, Microsoft Excel doesn't have a Change Case button for changing capitalization. However, you can use the UPPER, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case.

Can we change the case of the text without retyping it? ›

Select the text for which you want to change the case. On the Home tab, click Change Case . Choose an option from the menu: To capitalize the first letter of a sentence and leave all other letters lowercase, click Sentence case.

What is shift F3 used to change the case of a text? ›

Shift +F3 shortcut switches the text between uppercase, lowercase, and title case. You can also change the capitalization, or case, of selected text in a Microsoft Word document by clicking a single button on the Home tab called Change Case.

What do you mean by changing the case in a text? ›

Change Case is the option in ms word which allows us to change the cas of words in the sheet. The case menu offers four options; Sentence case: It capitalises the first letter of each sentence. Lowercase: It changes the text from uppercase to lowercase. Uppercase: It capitalises all the all letters of your text.

What is changing case with example? ›

Here are some examples of different types of change cases in a Microsoft Word document: Upper case: This changes all the selected letters to uppercase. For example, if the selected text is "the quick brown fox," it will be changed to "THE QUICK BROWN FOX." Lower case: This changes all the selected letters to lowercase.

What is a text case? ›

Case. A scheme for transforming the capitalization of characters within text.

What can you use to change text case? ›

Note: You can also select your text and press Shift + F3 until the style you want is applied. Using the keyboard shortcut you can choose only upper, lower or sentence case.

How do you highlight text and change the case? ›

In Microsoft Word:

Highlight the section of text to change and press SHIFT+F3 as many times as it takes to complete the case transition. With this routine, you can cycle through: lowercase, UPPERCASE, Sentence case, Title Case, and tOGGLE cASE.

What is a sentence case with an example? ›

In sentence case, the first letter of the first word is capitalized, and all other letters and words that follow are in lowercase, except for proper nouns (e.g., “Major heat wave arrives in California”).

What is title case Capitalization? ›

Title case or headline case is a style of capitalization used for rendering the titles of published works or works of art in English. When using title case, all words are capitalized, except for minor words (typically articles, short prepositions, and some conjunctions) that are not the first or last word of the title.

What is an example of a logical function? ›

a reference to a cell holding a logical value (that is, TRUE or FALSE). For example, =AND(B2,C2) will return the value FALSE if B2 and/or C2 contain the text FALSE. The AND function is used to compare the results of more than one condition test.

How do you change the case of text in Excel? ›

Select the "Formulas" tab > Select the "Text" drop-down list in the "Function Library" group. Select "LOWER" for lowercase and "UPPER" for uppercase. Next to the "Text" field, click the spreadsheet icon. Click the first cell in the row or column that you would like to change the text case.

Why is Shift F3 not working? ›

If you encounter the Shift + F3 not working issue, you can check whether the keyboard shortcut was changed or not. Taking Microsoft Word as an example, you should go to Word > File > Options > Customize Ribbon > Customize > All Commends > Change Case. If the current keys are not Shift + F3, you can revert it back.

How to switch the text between upper case lower case and Title Case? ›

The correct answer is Shift + F3. It is used to change the text between Title case, Upper case, and Lower case in Ms-word, Ms-powerpoint and Ms-Excel.

What is the step of changing the text to lowercase? ›

Select the text you want to alter. Press Shift+F3. Word changes the case of the selected text. Continue pressing Shift+F3 until the case is the way you want it.

Top Articles
What is the range of the Indoor Helium Mobile Hotspot? | Helium Mobile Hotspot Help Center
VA Loan Down Payment Requirements
Varsity Competition Results 2022
Dive Bars With Pool Tables Near Me
Social Security Administration Lubbock Reviews
Nj Scratch Off Remaining Prizes
Opsahl Kostel Funeral Home & Crematory Yankton
Tmobile Ipad 10Th Gen
Discover the Hidden Gems of Greenbush MI: A Charming Lakeside Retreat - 200smichigan.com (UPDATE 👍)
Relic Gate Nms
Walmart Tires Hours
Craigslist Indpls Free
Madison.ellee
Claims Adjuster: Definition, Job Duties, How To Become One
Cbs Local News Sacramento
How 'The Jordan Rules' inspired template for Raiders' 'Mahomes Rules'
Greater Keene Men's Softball
Mogadore Reservoir Boat Rental Price
EventTarget: addEventListener() method - Web APIs | MDN
My Time Banner Health
Portland Walmart closures attract national attention; Wheeler, Texas Gov. Greg Abbott spar
Oklahoma City Municipal Courthouse
Truecarcin
Icue Color Profiles
Prey For The Devil Showtimes Near Amc Ford City 14
suggest - Englisch-Deutsch Übersetzung | PONS
Cozy Bug Company Net Worth
A vintage funfair / fairground
Ella Phipps Haughton
Funny Shooter Unblocked
Gran Turismo Showtimes Near Epic Theatres Of Ocala
4201 Crossroads Wy, Rancho Cordova, CA 95742 - MLS 224103058 - Coldwell Banker
Used Fuel Tanks For Sale Craigslist
Craigslist Chester Sc
Eromancer Kemono Party
Anmed My Chart Login
Our Favorite Paper Towel Holders for Everyday Tasks
How To Delete Jackd Account
Chipotle Digital Kitchen Briggs Chaney
Fx Channel On Optimum
Walgreens Pharmacy On Jennings Station Road
The Whale Showtimes Near Cinépolis Vista
Hobby Lobby Locations Near Me
Protegrity Restoration Reviews
When Does Mcdonalds Inside Close
421 West 202Nd Street
The Penitent One Unmasked
Greenville Sc Greyhound
Auctionzipauctions
3220 Nevada Terrace Ottawa Ks 66067
Bbw Chan Lmbb
Clarakitty 2022
Latest Posts
Article information

Author: Fr. Dewey Fisher

Last Updated:

Views: 6068

Rating: 4.1 / 5 (42 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Fr. Dewey Fisher

Birthday: 1993-03-26

Address: 917 Hyun Views, Rogahnmouth, KY 91013-8827

Phone: +5938540192553

Job: Administration Developer

Hobby: Embroidery, Horseback riding, Juggling, Urban exploration, Skiing, Cycling, Handball

Introduction: My name is Fr. Dewey Fisher, I am a powerful, open, faithful, combative, spotless, faithful, fair person who loves writing and wants to share my knowledge and understanding with you.