When we work with the Microsoft Excel spreadsheet, it always happens that some problem arises that we cannot solve and we wonder what I can do. But the real problem lies in the ignorance and use of its functions. But in your defense we can tell you that there are many and in this article we are going to teach you how to switch from lowercase to uppercase in excel without formula.
To use this function we are going to apply several different forms but that will offer us the same results and is to change the letters from uppercase to lowercase and vice versa. For this we can use the Function MAYUSC With this, the entire text is capitalized. But we can also use the function NAME to just change the first letter.
In addition, there is still another function and the one known as Quick Fill, which will allow each initial letter to be in uppercase. Here we will explain how to use each of them, as we did in the tutorial that explained how to insert and configure ActiveX controls in an Excel spreadsheet, all this in a very simple way.
How to change from lowercase to uppercase in Excel without formula
To start with our tutorial we are going to explain how the function is used MAYUSC, for this you went to your spreadsheet and write the text in lowercase. This you are going to do in any column, now you must add a new column. This should be next to the column where you have written the text.
To do this, you position yourself on the letter of the column where you have written the text, for example, if you wrote in column A, you position yourself on this letter.
Then you right click and in the context menu, you are going to select the Insert option. Now scroll to the right in the first cell of this new column and you are going to put the UPPER function formula.
To do this, you must click on the function option found in the tools menu on the start tab. This is located on the right side and says AutoSum click on the arrow to display the different formulas and choose UPPERCASE.
You may also be interested in:
And then you must write between the parentheses of the formula the column where the text and the first cell are written and then press the Enter key.
Immediately the text that you have written in the first cell of the first column will appear in the first cell of the second column in uppercase. Now just click on the bottom corner of the cell and drag to the end for it to be copied.
How to change from lowercase to uppercase using quick fill
To use this function, the first thing you must do is write in the first column a series of first and last names, all in lowercase. When activating this function, it will automatically switch to capital letters the first letter of the first name and the first letter of the last name. On the right side of this column there should be a blank column, if not, you should insert one.
Now you must choose the first cell of the blank column and this must be next to the first cell that you started to write the names.
Click on this cell and write the name you wrote in the cell next to it. But this time make sure that the first initial letter of the first and last name is in uppercase, then you must press the Enter key.
Now go to the top menu and choose the Data tab and here you must find and select the Quick Fill option. You can also activate this function, using the shortcut keys, you must press the Ctrl + E key. In this way, the data contained in column number 1 will change in this column, that is, it will place the initials of the names and surnames in capital letters.
You may also be interested in:
And finally you just have to delete the column where the texts are in lowercase, this way you can use this handy function in your spreadsheet. And in this way we finish this article and show you how to switch from lowercase to uppercase in excel without formula.
I'm sorry this content was not useful for you!
Let me improve this content!
Tell me, how can I improve this content?