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 is ultimately 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 a cell with text) - converts all entered text (or text from the selected cell) to a lowercase view;
- =( ) – ( ) , .
Excel « », , . , . , Excel .
,
, 2 Excel « » ( ). :
, .
, , Excel , , , . ... .
Excel:
, . :
- . , . (), – (;[ ]) , 1 ( , ).
- .
- Excel « », , . , . (; [ ]), . , , ? , , -1. , .
- (&).
, « » .
|
|
|
| | =(A2) |
| | =((A2)) |
| | =(((A2))) |
| 22 | =((A2))-1 |
| | =((A2); ((A2))-1) |
| | =(((A2); ((A2))-1)) |
| | =(((A2))) & (((A2); ((A2))-1)) |
, Excel « » , , .