How to solve a problem in Excel "First letter capital"

Many people ask themselves: how to make the first letter in Excel capital? Such a problem, indeed, occurs very often. For example, users of the workbook make inaccurate data, making the surname from a small letter, allowing extra spaces, mistakes, inaccuracies, which leads to the fact that uniformity is ultimately difficult to achieve.

This article is devoted to what tools in the Excel spreadsheet program from Microsoft are provided by the developer to manage capital and capital letters at their discretion.

Excel Features

In Excel, there are the following ready-made functions for working with strings:

• = PROPOSE (text or cell with text) - translates all the entered text (or text from the selected cell) to the title;
• = STRONG (text or cell with text) - translates all the entered text (or text from the selected cell) to the lowercase;
• = PROPONACH (text or cell with text) - this function will capitalize the first letter of each word (space-separated) text, and make the remaining letters small.

Run the task in Excel "The first letter is uppercase," as we can see, none of the proposed functions can. To do this, we use a combination of ready-made functions, but consider this a little later. First, we'll analyze how to make capital and capital letters in Excel based on the above functions.

Working with the functions PROPRESS, STRONCH and PROPONACH

To immediately check the result of all three functions, we'll enter a simple line in the cell A2 of the Excel worksheet: "Apple Fresh Antenna" (specially allowing an extra capital letter to check the result of the work). In the next column, enter the following formulas and compare the result:

As you can see, all functions work according to the description.

Agree, it would be convenient, that in Excel the first letter of the capital became such a simple choice of one function, but, unfortunately, this is impossible. We'll have to create the formula we need ... Let's select a separate section for this.

Excel: first capital letter

To solve the task, it is necessary to disassemble it logically into separate stages. In this case, we can distinguish the following:

1. Select the first letter of the text. At the same time, it is necessary to take into account that often users make extra spaces before entering text. Delete the extra spaces with the help of the BLOCK function (text), and select the first letter - the function LEVSIMV (text; [number of characters]) with the second argument equal to 1 (it is selected by default, so you can release it).
2. Select the first letter with the help of the PROPOSAL function discussed in the previous section and translate it into the title view.
3. Since we need to perform a task in Excel, "First letter capital", this implies that the rest of the text will be uppercase. Be that as it may, now we need to attach the remaining text to the first letter. To do this, we can use the PRIMOV function (text, [number of characters]) that selects the required number of characters from the end of the text. And what, properly speaking, is the right thing? You need as much as the length of the string minus the first character, that is, -1. After completing these steps, the result should be reduced to a capital form.
4. It remains to connect the results of the second and third points with the ampersand (&).

All this sequence is fixed in the table, for clarity, we insert a few extra spaces in front of the text "apples and antonovka fresh".

As you can see, solving the problem in Excel "The first letter of the title" turned out to be not so difficult, the main thing is to present the entire logical sequence of the stages.