WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to change lowercase to uppercase in Excel

August 1, 2022
11.2K Views

When you create a new worksheet in Excel, you're given the option to save it in either lowercase or uppercase. This can be helpful if you want to keep your workbooks organized by case, but it can be confusing if you need to reference a specific cell value. In this article, we'll show you how to change lowercase to uppercase in Excel so that all values are uppercase.

Changing lowercase to uppercase in excel worksheet to uppercase can make the data more legible and organized. This tip is especially helpful if you are working with a large volume of data that needs to be easily read.

If you are working with a lot of data in Excel, it can be helpful to change the letters in the data so that they're all in uppercase.

How to Change Lowercase to Uppercase in Excel

You may think that changing lowercase to uppercase in Excel is easy, but it’s way more tiring than you think. Imagine you have extensive data which needs to be edited. Changing all lowercase text in an Excel worksheet to uppercase can make the data more readable and organized. The tip below helps where a user has a huge amount of data to edit and present forward.

Step 1: First, you must type in a series of texts in a column. You can write the names of food, animals, places, and much more.

Adding texts


Step 2: You may use the UPPERCASE or Proper function to edit the text in the file.

Step 3: You need to add and move the column to the correct data. You must ensure an empty column next to the column containing your data.

Step 4: If there is no blank column next to your data column, right-click the column letter above your data column and click insert.

Inserting a right column


Step 5: After accomplishingit, click on the first cell of your new column. This is the cell to the right of the first data cell you wish to capitalize.

Selecting a cell for results


Step 6: Click on the Fx. There you can add an equal sign (=) and writer UPPERCASE. After doing it, you must open a bracket and write the cell number ( in our case Cell A1)

Using fx to add formula


Capitalizing first letter using a formula


Step 7: Now press enter. Boom! The data on cell A1 will all be in upper case in cell B1. You can use auto-fill to fill in the formula to other cells.

Capitalizing first letter of a text


Step 8: You’ll noticethat your data has been converted into UPPERCASE using a simple formula.

2. How to Use the Excel Function to Change Lowercase to Uppercase in Excel

Excel has many advanced tools and functions that allow its users to do wonders. If you want to convert the first letter or whole data to uppercase without retyping or formula in an Excel sheet, you can use the Excel function to do that. This can be done both in Windows and Mac quickly and smoothly. It’s best when you don’t want to auto-fill, forget the formula, or don’t want to type it. If you are working with a lot of data in Excel, it can be helpful to change the letters in the data so that they're all in uppercase.

Here’s a step-by-step guide on how to use the Excel function to change the lowercase to uppercase in Excel. Please follow the steps carefully.

Step 1: The first thing you need to do is type a data series. This data can be anything. You can type names, food items, places, accessory names, or other things.

Adding data


Step 2: Add and move the column to the correct data. You must add a blank column at the right of the column where you entered the data.

Step 3: If you already have an empty column at the right of a column that contains data. You can skip this step. Or else click on the data column and insert and on insert column right.

Inserting a right column


Step 4: The next thing you need to do is click on the first cell on the column, which is on the right of the data column. This cell is the cell where you want your results of capitalized data.

Selecting a cell for results


Step 5: Click on fx This is the function button just above your data. The Insert Function window will expand. You’ll see the category column in the new window. Select the text category in it.

Using fx to use function


Step 6: Then you’ll see a “select a function” section. Select the “Uppercase” function from it. Furthermore, highlight the text you want to capitalize.

Step 7: Click on “Ok,” and you’ll see a dotted line on the column with your results.

Step 8: You’ll see that your Cell (normally Cell B1) is in Uppercase now. You can now use auto-fill to convert all the cells to uppercase instantly.

Capitalizing first letter of a text


Step 9: Instead of choosing one cell to convert from lower to uppercase, you can select the whole column to quicken the work.

Step 10: Boom! It’s all done. You have converted all your data from lowercase to uppercase within a few minutes.

3. How to Capitalize the First Letter of a Text String in Excel

Many people use Excel to store numerical data; however, some use it for text data and to alter them. Many users of Excel software are working professionals, but they fail to capitalize the first letter of their data. The first letter of the data must be capitalized as it’s the first impression, making the data consistent and maintaining readers' attention. The below-mentioned steps will guide you through how to capitalize the first letter of your data in Excel.

Please read and follow the steps carefully.

Step 1: Excel has a significant function named “PROPER Function.” The purpose of the PROPER function is to make the first letter of every word proper (as in capitalizing it).

Step 2: The first thing you need to do is to get the data. You can copy data from somewhere and paste it into an Excel sheet. You can manually write the text too.

Step 3: After having data in a column. You need to insert a new column right to the data column.

Capitalizing first letter of a text string


Step 4: Select the first cell (usually Cell B2), and in the fx section, write this formula:

=PROPER(A2)

Step 5: This will capitalize every word’s first letter. The word can be one or more in one cell, as seen in the screenshot.

Capitalizing first letter of a text string


Step 6: It’s done. You’ll see the results on the right side column of the data column. You can use auto-fill to fill the formula to other cells.

Here’s how to capitalize only the first letter of the first word only in Excel.

Sometimes people need to capitalize only the first letter of the first word and keep the rest as it is. To do this, follow the below steps carefully.

Step 1: Add your data manually or copy-paste from the source.

Step 2: Add a column to the right side of the data column.

Capitalizing first letter of first word only


Step 3: Select the first Cell (usually Cell B2).

Step 4: Click on the fx section and type this formula:

=UPPER(LEFT(A2,1))& RIGHT(A2,LEN(A2)-1)

Step 5: This formula uses the left function to get the first letter of the first word, and with the help of the Upper function, it capitalizes the first letter of the first word.

Capitalizing first letter of first word only


Step 6: Additionally, with the help of the right function, it keeps the other text string the same as it is.

Step 7: You’ll see that the first letter of the first word of your text string has been capitalized, and you can use auto-fill to apply this formula to every cell.

Frequently Asked Questions (FAQs)

How can I capitalize the text in Excel without changing the original data?

You can use a helper column to capitalize text in Excel without altering the original data. In the new column, apply the desired capitalization function to the corresponding cell in the original column. This way, you'll have the capitalized text alongside the original data.

Is there a way to automatically capitalize the first letter of each word in Excel?

Yes, you can use the PROPER() function in Excel to automatically capitalize the first letter of each word in a cell. Applying the function to the desired range or specific cell will capitalize the first letter of each word while converting others to lowercase.

Can I capitalize text within a specific range of cells?

You can capitalize text within a specific range of cells in Excel by using formulas or the built-in text manipulation functions. Apply the desired function (e.g., PROPER(), UPPER()) to the range of cells, or use formulas that reference the cells you want to capitalize.

Summary

Excel is a fantastic software that can help people in numerous ways. The article discussed how people can use three different ways to capitalize the letters, specifically their words' first letters. The article guided users in-depth with clear and simple steps with screenshots to enable them to work more efficiently. However, it’s clear that Excel isn’t free software, and many people don’t wish to purchase it.

Here comes the best alternative to Excel, WPS Office. WPS Office is software used by millions of people globally. The software allows users to multitask using Excel, Word, PPT, and PDF on one application. Sounds magical? It is! Moreover, WPS Office is free and provides free WPS Templates on its website. Don’t wait! Download now!


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