How to solve the problem in Excel “First capital letter”

Many people wonder: how to make the first letter capitalized in Excel? Such a problem, indeed, is very common. For example, users of a workbook inaccurately enter data by entering a surname with a lowercase letter, allowing extra spaces, clerical errors, inaccuracies, which leads to the fact that uniformity in the end is difficult to achieve.

This article focuses on what tools Microsoft has provided for the developer in the Excel spreadsheet editor to manage the uppercase and lowercase letters of their choice.

Excel features

Excel has the following predefined string functions:

• = CAPITAL (text or cell with text) - converts all entered text (or text from the selected cell) to the uppercase view;
• = LINE (text or cell with text) - converts all the entered text (or text from the selected cell) to the lower case;
• = PROBLEM (text or cell with text) - this function will capitalize the first letter of each word (separated by a space) of the text, and make the remaining letters small.

As we see, none of the proposed functions can complete the task in Excel “The first letter is uppercase”. To do this, we will use a combination of ready-made functions, but we will consider this a bit below. First, let's analyze how to make uppercase and lowercase letters in Excel based on the above functions.

Work with the CURRENCY, LINE, and LIST functions

In order to immediately check the result of all three functions, we enter in cell A2 of the Excel worksheet a simple line “apples and Antonovka fresh” (specially allowing an extra capital letter to check the result of work). In the adjacent column, enter the following formulas and compare the result:

As you can see, all functions work as described.

Agree, it would be convenient for the first capital letter in Excel to become such a simple choice of one function, but, unfortunately, this is not possible. We have to create the necessary formula ourselves ... We will select a separate section for this.

Excel: first letter is uppercase

To solve the problem, it is necessary to logically disassemble it into separate stages. In this case, the following can be distinguished:

1. Select the first letter of the text. It should be borne in mind that often users fill in extra spaces before starting to enter text. The EXTRACTIONS function (text) will help us to remove unnecessary spaces, and the LEVELS function (text; [number of characters]) with the second argument equal to 1 will help us to select the first letter (it is selected by default, so it can be released).
2. With the help of the PROPISN function described in the previous section, translate the selected first letter into the uppercase form.
3. Since we need to complete the task in Excel “First capital letter”, this implies that the rest of the text will be capitalized. Be that as it may, now we need to append the remaining text to the first letter. The PRIVSIMV function (text; [number of characters]) will help us do this, highlighting the desired number of characters from the end of the text. And what, in fact, is necessary? You need as much as the length of the string minus the first character, that is -1. After completing these steps, you need to bring the result to a capital form.
4. It remains to combine the results of the second and third paragraph using the ampersand (&).

We fix this whole sequence in the table, for clarity, we will add a few extra spaces in front of the text “apples and Antonovka fresh”.

As you can see, solving the problem in Excel “First capital letter” was not so difficult, the main thing is to present the entire logical sequence of steps.