excel one click capitalization letters

Select the promote function in the text bar, detailed steps:

1. First of all, you need to convert the letters to uppercase excel**.

We can see that there are already 9 lines of letters on column A, and we are going to change the corresponding space in column B to the first letter capitalization.

2. If you know this function, you can directly enter =proper(a1) in b1. If you don't know, just select the formula in the menu bar, insert the function, and the dialog box shown in the following figure will appear. Select the promote function in the text bar.

3. Then in the pop-up dialog box, click A1, you will find that the English words of B1 have become capitalized, and then move the mouse cursor to the lower right corner of B1, and the cursor will become a solid cross to pull down, and you will find that all the words have become capitalized.

4. If you want to copy him elsewhere, box select all words with the first letter capitalized, right-click to copy, left-click the space that needs to be pasted, and then right-click to select selective paste, value, you will find that the words that have been changed before also appear in **.

What you want to ask about is the uppercase and lowercase letter conversion.

First of all, we open the worksheet first, after opening it, it will appear as shown in the figure, at this time we can see that column A is all uppercase letters, then we click on cell B1, and after clicking, enter =lower() in the cell.

Please click Enter a description.

After typing, we click on the cell that we want to convert from uppercase to lowercase, at this time we click on the A1 cell, and then enter the closing parenthesis after clicking).

Please click Enter a description.

After pressing the enter key, it will appear as shown in the figure, at this time we can see that the b1 cell has become lowercase English letters, if we want the English of column A to become lowercase, then double click the plus sign behind the b1 cell to fill it all.

Please click Enter a description.

Please click Enter a description.

End Method Step 2

When we open the worksheet, we can see that there is a "Public" button in the menu bar, click on it.

Please click Enter a description.

Please click Enter a description.

Please click Enter a description.

Please click Enter a description.

Please click Enter a description.

Please click Enter a description.

Please click Enter a description.

1.The first step is to find the excel2016 software on the computer, click to enter the main interface, and then we create a new "test data" document, and enter the English letters in it.

3.The third step is to press the Enter key when you are done, wait quietly for the lower right corner of the B2 cell to change to a solid cross, and then we can move down the "autofill" data. This way, we can see that we have successfully switched to lowercase letters.

4.Fourth, some friends want to change all the letters into lowercase letters, then it is recommended to enter the formula [=lower(A2)] in cell C2.

5.Fifth, please press enter in the screen, so that we can turn all the C2 cells into capital letters.

6.Finally, please move the cursor to the **c2 cell and put it in the lower right, and when the cursor turns into a cross, we can move down to automatically fill in the data below.

1.If the excel version is higher, you can use the "Chinese capital number" in the "special" in the cell format, and the "meta corner score" will be automatically generated.

2.If the excel version is lower and the above method cannot appear "meta angle minutes", you can enter the following formula:

iferror(if(mod(c4,1)=0,text(rounddown(c4,0),"[dbnum2]")&"Yuan whole",text(rounddown(c4,0),"[dbnum2]")&"Yuan angular minutes"),"The data you entered is incorrect")

C4 can be changed to the number of the cells you need to convert.

Methods and steps to convert lowercase to uppercase letters in excel**:

Open Excel and enter the appropriate content on it.

Move the cursor to cell B2 and enter the formula =lower(A2). Note: The case of the lower function does not affect the final result. The cells in parentheses are determined according to your actual needs.

Here's another function. Convert uppercase letters to the first letter uppercase and the rest of the letters lowercase. Delete column B. Re-move the cursor to cell b2 and enter the formula =proper(b2).

How to convert lowercase letters to uppercase letters in excel.

If A1 is a capital letter, enter it in B2.

The formula below.

upper(a1) pull-down to complete.

Assuming that A is a lowercase letter, enter the following formula in B1.

upper(a1)

Pull-down padding.

There are no shortcuts, and you can only use functions to convert.

1. Convert cell lowercase to uppercase, use the upper function, the formula is =upper(a2).

2. If you want to convert all the letters in the cell to lowercase, use the upper function, the formula is =lower(a2).

3. If you need to convert all the letters in the cell to the form of the first letter uppercase and the rest of the letters in lowercase, you can use the promote function. The formula is =proper(a2).

Letter case and lowercase??

Letters are uppercase, press caps in English

Isn't it okay to switch the lock key?

Use the following function:

upper(text) to convert the text to uppercase.

proper(text) converts the first letter of a text string and the first letter after any non-alphabetic characters to uppercase. Convert the rest of the letters to lowercase.

lower(text) converts all uppercase letters in a text string to lowercase letters.

Here's how:

1.Open the Excel you want on your computer.

<>4.Next, hover the mouse over the cell where the result is obtained, and a black "small cross" will appear in the lower right corner of the cell, click and drag it down.

5.The image below is the final result.

Tools Raw material excel2018 edition, computer. 1. Open the computer to find and double-click to open the Excel2018 version of the new work ** software; 2. Click to open the excel new work**, in order to demonstrate the content of the letters in the ** and any small whispered letters; 3. After any letter, select the cells in column b of the auxiliary column and enter =upper(a1) in the column to call the oak; 4. After entering the formula in the column, press "Ctrl+Enter and Side" to fill the shirt to complete the conversion.

Excel wonderful course recommended which line to accompany the excel** zero basic introduction to quick mastery of excel-worksheet office automation operation skills excel-electronic** function practical tutorial excel-electronic** pivot table excel-electronic** diagram drawing tutorial The use of office software is a very basic skill, which can help people quickly carry out word processing, production, data processing, making speeches, etc. The application range of office software is very wide, from statistics to records, digital office and so on are inseparable from the assistance of office software. In order to help users quickly master the use of office software, there are word, excel, ppt, mind map and other office software boutique teaching courses, you can try to learn for free, and those who have not yet mastered office software must not miss it.

Excel tutorial to change lowercase to uppercase with one click:

1. Open the excel** you want in your computer.

3. Next, put the mouse on the cell where the result is obtained, and a black "small cross" will appear in the lower right corner of the cell, click and drag it down.

4. This is the final effect.

The above is the operation method of excel to change lowercase letters to uppercase with one click, excel is currently a popular personal computer data processing software, with **, charts, functions, databases and other functions, if you want to learn excel by yourself, you must go to Yutu to take a look.