Now we open a new Word document and there we use the Ctrl + V or Edit / Paste keys to insert the range of Excel 2019 that we have copied: Microsoft Word integrates a function to convert text in a much simpler way and we can use it to convert our Excel 2019 text, for this we select the range to convert in Excel and proceed to copy it using the Ctrl + C keys or right click / Copy:
#CONVERT TEXT TO UPPERCASE EXCEL 2010 HOW TO#
How to use Microsoft Word to convert text in Excel 2019 or Excel 2016 On the contrary, if we want all the text to be converted to uppercase, we must use the SHIFT function like this: = SHIFT (A2) As a result we will obtain the following:Ģ. We drag the entire formula back to the other cells so that it is copied and this will be the result:
![convert text to uppercase excel 2010 convert text to uppercase excel 2010](https://cdn.ablebits.com/_img-blog/change-case/convert-to-uppercase.png)
Now, if we want to convert all the text to lowercase, we must use the MINUSC function, this is responsible for converting the selection to lowercase, in cell B2 we will enter the following: = MINUSC (A2) This formula can be dragged to the other lower cells and so it will be copied, as a result we see that the uppercase values become proper names: In cell B2 we enter the following formula: = NOMPROPIO (A2) How to change upper and lower case in Excel 2019įor this case it will be necessary to insert a column next to the column that contains the text we want to convert, for this we right click on the column and select "Insert"įor this first example we will capitalize all the data in column A, then, we will use the NOMPROPIO function which allows you to convert the names in capital letters to proper names, so that only the first letter of each name will be capitalized.
![convert text to uppercase excel 2010 convert text to uppercase excel 2010](https://www.addictivetips.com/app/uploads/2010/10/896d1277290365changefontcaselowerupper.jpg)
We will learn to convert text to uppercase or lowercase through these formulas in Excel 2019 but the same process applies to Excel 2016. These functions are integrated formulas that have been designed to carry out specific tasks within the Excel sheet. This is useful for editing titles, legends or others in the active sheet, unlike Microsoft Word, in Excel we do not have a Change case button to carry out this task, but since Excel is an app based on multiple functions, we can use the functions SHIFT, MINUSC or NOMPROPIO to automatically convert existing text from lowercase to uppercase, from uppercase to lowercase, or to the format of our own name.
![convert text to uppercase excel 2010 convert text to uppercase excel 2010](https://cdn.extendoffice.com/images/stories/doc-excel/change-uppercase-to-lowercase/doc-change-to-lowercase-2.png)
#CONVERT TEXT TO UPPERCASE EXCEL 2010 FULL#
Microsoft Excel 2019 is the new bet that Microsoft has developed for the management of large amounts of data in a centralized way where administration options abound, we know that Microsoft Excel is full of functions and formulas that will make each data worked a unique experience of management.Īlthough Microsoft Excel is one of the most complete applications at the level of tools and functions, it lacks some basic ones such as converting text to uppercase or lowercase.