Catalog

How To Change Small Letter To Capital Letter In Excel_ A Comprehensive Guide

January 30, 2024 1.6K views

 Ever faced the problem of changing small letters to capital letters in Excel? It's a common challenge, but don't worry! This article will uncover simple methods to make this change effortlessly. Whether you're dealing with data or crafting charts, we'll guide you on "How To Change Small Letter To Capital Letter In Excel" without hassle.

Changing Text Case With Excel Functions

Microsoft Excel, a powerful spreadsheet tool, doesn't have come a direct Change Case button like Word. However, it offers specialized functions to modify the case of text within cells. Excel's uppercase, lowercase, and proper case functions in Excel automatically change existing text to these pre-built formulas. Here's a closer look at these functions:

UPPER Function converts all characters in a given text to uppercase.

Formula: =UPPER(A1)

Example: If cell A1 contains "hello world," it will display "HELLO WORLD."

LOWER Function - This function changes all characters in a given text to lowercase.

Formula: =LOWER(A1)

Example: If cell A1 contains "HELLO WORLD," the result will be "hello world."

PROPER Function - This function converts the first letter of each word in a given text to uppercase and the rest to lowercase, following proper noun capitalization rules.

Formula: =PROPER(A1)

Example: If cell A1 contains "hello world," the result will be "Hello World."

Change Small Letter To Capital Letter In Excel

Use UPPERCASE Function

Step 1: Open your Excel document and locate the cell containing the text you want to convert into uppercase.

How To Change Small Letter To Capital Letter In Excel’


Step 2: Select the cell.

’How To Change Small Letter To Capital Letter In Excel


Step 3: Type in the equal sign (=) and begin typing the function 'UPPER'.

’How To Change Small Letter To Capital Letter In Excel’


Step 4: Click on the suggestion for the 'UPPER' function as it appears.

Step 5: Define the cell containing the text you want to convert into uppercase. In this example, it's cell B3. Press Enter after clicking on B3.

’What Is The Shortcut To Change Small Letter To Capital Letter In Excel’


Step 6: Now, the text is all in uppercase. For all the rows, you can use drag and drop to change lowercase letters to uppercase by copying the function.

What Is The Shortcut To Change Small Letter To Capital Letter In Excel


Step 7: If you wish to store only the values and not keep the function in the data table, select the converted data.

Step 8: Copy the contents of the cells by pressing the control key [Ctrl] and C simultaneously.

Step 9: Use 'Paste' at the top to paste them in the same place, but select the option 'Values' to ensure that all the cells contain the converted text only.

What Is The Shortcut To Change Small Letter To Capital Letter In Excel’


Use Power Query Function

Step 1: Choose the cell you want to convert in the data set.

How To Change Small Letter To Capital Letter In Excel Without Formula’


Step 2: Click the Data tab in Excel.

Step 3: Select the 'From Table/Range' option.

Step 4: In the Create Table dialog that appears, click OK.

How To Change Small Letter To Capital Letter In Excel Without Formula


Step 5: You will see the selected data is loaded into the Power Query Editor.

How To Change Small Letter To Capital Letter In Excel


Step 6: Right-click on the column header of the data you wish to convert.

Step 7: Choose the 'Transform' option.

Step 8: Select the 'UPPERCASE' option for converting all letters into capital letters.

How To Change Small Letter To Capital Letter In Excel’


Step 9: To load this data into the same Excel worksheet, go to the Home tab, then 'Close & Load', and choose 'Close & Load to…'.

’How To Change Small Letter To Capital Letter In Excel’


Step 10: In the Import Data dialog, select 'Existing worksheet', then choose the cell where you want to place the data (for example, cell D2) and click OK.

’How To Change Small Letter To Capital Letter In Excel


Step 11: Whenever you add new data to the Source Table or make some changes to that table, you don’t need to repeat these steps again. Refresh the output table by right-clicking it.

A Free Alternative To Microsoft Office - WPS Office

‘WPS Office free download’]


WPS Office is a feature-rich and highly compatible productivity suite that caters to a wide range of users, from beginners to professionals. Offering comprehensive tools and functionalities, it is a prominent alternative in the productivity software market.

Free For Users

One of the key advantages of WPS Office is its free availability. It's designed to provide high-quality features without the associated costs, making it a preferred choice for individuals and small businesses.

Strong Compatibility

WPS Office boasts strong compatibility across various devices and operating systems. Whether you're using Windows, Mac, or Linux, WPS Office ensures seamless integration and operation, making it a highly versatile office tool.

User-Friendly Features And Functions

WPS Office offers an extensive range of features that are accessible even to those who might not be proficient in using programs like Excel. From basic word processing to complex spreadsheets, WPS Office's user-friendly interface enables users to perform tasks easily.

Trustpilotstars4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
avator
Algirdas Jasaitis
logo

FAQs

How To Change Capital Letter To Small In Excel?

To change capital letters to small letters in Excel, you can use the formula =LOWER(A2) in a cell. This formula will convert the text in cell A2 to lowercase.

How To Reverse An All-Caps Error In Word & Outlook Without Retyping?

To reverse an all-caps error in Word & Outlook without retyping, select the text and use the "Change Case" feature on the Ribbon. Alternatively, in Windows press SHIFT + F3 (with FN if on a laptop) or press fn + SHIFT + F3 on a Mac, tapping until the desired case is applied.

Summary

The article presents detailed guidance on changing the text case in Excel using functions such as UPPER, LOWER, PROPER, and Power Query. By following step-by-step instructions, users can effortlessly convert text to uppercase, lowercase, or proper case. These comprehensive methods provide easy solutions to a common challenge, allowing even novice Excel users to modify text within cells efficiently.

In the context of alternatives to Excel, WPS Office is spotlighted as a standout choice. Available for free, WPS Office offers strong compatibility across various platforms and boasts user-friendly features. It is suitable for tasks ranging from basic word processing to intricate spreadsheet manipulation, making it a compelling and cost-effective alternative to traditional spreadsheet tools like Excel.


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.