+3 votes
65 views
Uppercase First Letter Excel

in Office by (552k points)
reopened | 65 views

1 Answer

+4 votes
Best answer

How to convert first letter to uppercase Excel

To stay up to date, remember to subscribe to our YouTube channel!
SUBSCRIBE ON YOUTUBE

 

Excel offers us a wide set of options to work with data of all kinds and this is achieved thanks to the functions and formulas integrated into its sheets, a very useful one is the PROPER function which will help us in those moments where words do not have the desired format, such as names or initials, and we want the first letter to be capitalized for organization and presentation reasons. Many times we need to capitalize the first letter of Excel words to give our data a more formal format and if they are large volumes it can be somewhat tedious. Therefore, here we want to show you a quick and interesting process where you can capitalize the first letter of Excel words..

 

This PROPER function is responsible for converting the first letter and the letters that follow a character to uppercase as long as this is not another letter in the selected cell, then all other letters will become lowercase.

 


TechnoWikis will explain how to use this function to convert the first letter to uppercase in Excel.

 

How to convert first letter to uppercase Excel

 

Step 1

To start we open Excel and there we will see how the words are, in this case names, without a proper format:

 

image

 

Step 2

We are going to place the cursor in the cell where the conversion will be carried out and there we will use the function called PROPER which has the following syntax:
 PROPER(cell) 
image

 

Step 3

By pressing Enter we can see how all that text string goes to the correct format of the first capital letter:

 

image

 

Step 4

It is possible to drag that formula to the other cells so that this process is applied:

 

image

 

step 5

In case we want to copy the results to the source cell, we are going to select and copy the cells with the result using the following keys:

 

Ctrl + C

 

 

image

 

step 6

Now we are going to press the right mouse click and we are going to drag these values ​​to where these values ​​will be, doing this will open the following pop-up window:

 

image

 

step 7

We click on the option "Copy here only as values" so that the formula is not copied and we will see the words with their first capital letter:

 

image

 

step 8

Now we can delete the values ​​of the formula that we have used:

 

image

 

We see how it is very simple to convert the first letter to uppercase in Excel thanks to this dynamic function..

 


by (3.5m points)
edited

Related questions

+4 votes
1 answer
+5 votes
1 answer
+4 votes
1 answer
asked Oct 24, 2022 in Office by backtothefuture (552k points) | 77 views
+3 votes
1 answer
asked Jun 24, 2019 in Office by backtothefuture (552k points) | 212 views
+4 votes
1 answer
asked Oct 21, 2019 in Office by backtothefuture (552k points) | 302 views
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users