How to change lowercase to uppercase in excel

Watch How to change lowercase to uppercase in excel - Mr. Devotor on Dailymotion

Transcript

00:00in this excel tutorial i will guide you the fastest way to make text uppercase in excel

00:04so for example you want to convert the k column which is the brand column to in uppercase then

00:13how you can do that put the equal sign type uppercase function and open the bracket select

00:22the cell reference close the bracket and hit enter and here you can see that so use the fill handle

00:28to make all brands into the uppercase so if you have a bulk data so use the power bi query so how

00:38you can do that for example again select this cell select the entire range and then go to the data

00:47and click on the from table range and click on the ok a new window will be open

00:56in the power query editor

00:59and then go to the transform and click on the format and here you will see that uppercase click on that

01:13and here the all brands are converted into the uppercase so go to the home and now close and

01:24load click on that close and load then it will be open in the new tab and you can see that the

01:32entire brands are converted into the uppercase so these are really helpful for those who use the bulk

01:38data so in this way you can convert any data into uppercase in excel if you think this video is helpful

01:46please support my channel thanks for watching