Skip to playerSkip to main content
  • 2 days ago

Category

😹
Fun
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
Be the first to comment
Add your comment

Recommended