How to capitalize first letter in Excel

For example, I have a list of names - some are fully capitalized, some are proper while some use lower case only. I want to standardize them to have proper names.

To do it in Excel, here is the answer:

a) Enter the formula =PROPER(BY5) as shown below where BY5 corresponds to the cell that needs to be properly capitalized.

Copy the formula for the rest of the range as required.

excel how to capitalize first letter


You can find similar Excel Questions and Answer hereunder

1) Find and count instances of a character in a string in Excel

2) I have a WorkBook that loads a form automatically when it is opened. In Excel, how can I suppress the form from loading on file open when required?

3) How to do worksheet protection with VBA in Excel

4) How can I hide all comments in my WorkSheet using VBA?

5) How to format variable with VBA with the very useful format function. Define the number of decimal, the way a date is formated

6) How to you use the events when the user clicks on message boxes on the screen.

7) How can I ensure that important files always appear on the recent Excel workbooks list?

8) How to modify strings in VBA, what are the functions you can manipulate strings with

9) How to see to which cells a cell is connected or used by. How to see the dependents of a cell

10) String split in vba in Excel


Here the previous and next chapter