00:00in this video i will show you how to convert all letters in capital in excels the fastest way to
00:06convert text in a cell is to use the upper function for this you need to use the formula
00:12for example you want to convert all these letters into capital for this you need to put the equal
00:18sign and type upper and open the bracket and select the cells reference and close the bracket
00:27hit enter and here it is so simple you just need to drag this formula to apply on the other
00:33rows as
00:34well and here you can see that if you don't want to use formulas excel can learn what you want
00:39to
00:39do based on the patterns suppose your local cases names are in column a for example ms excel so in
00:47the
00:47column b type the first name exactly as it appears in column a but in all caps like this one
00:59now hit enter and now type the second name in all caps in the cell below it for example again
01:06excel
01:09and now hit enter now press ctrl plus e on your keyboard to trigger flash fill manually like this one
01:19this is so simple and easy moreover if you have thousands of rows and want a permanent solution
01:26that updates automatically for this you need to select your data range and then go to the data tab and
01:35click on this table and range and click ok
01:45now your data will be open up in the power query editor so in the power query editor right click
01:52on the
01:52column header and select to the transform and click on the upper case and here you can see that your
02:01entire
02:01data has been converted into the capital letters you just need to close and load
02:10so excel will transport your all data into the new sheet where you can see that so with this way
02:17you
02:18can easily convert all data in capital in excel if you think this video is helpful please quote my channel
02:24thanks for watching
Comments