00:00if you are looking for how to auto capitalize the first letter in excel then keep watching
00:05the video and here are the simplest and best ways to auto capitalize the first letter in
00:10excel with four ways depending on what you need so the first method is the flash field
00:16you just need to type first letter for example emran and khan and hit enter and then
00:28press ctrl e to flash field and the second method is to use the proper function so
00:36put the equal sign write proper open the bracket and select the cells and close the bracket hit enter
00:46and here you can see that so use the fill handle to make other names capitalize the third method
00:53is the bi query for this you need to select the range of the data and then go to the data and go to the
01:02from table and range click ok a new power query editor will be open and then go to the
01:11transform and go to the format and here you will see that capitalize each word and here you can see
01:23that the first word is capitalized and go to the home go to the close and load go to the close and load
01:36the data will be open in the new tab just select it ctrl c and go to the
01:49your tab ctrl v or a special and values and here you can see that so in the fourth method if you want to
02:02only first letter capitalize then you need to put this formula put the equal sign type
02:09upper function and open the bracket type left and open the bracket select the cells comma type 1
02:221 close the bracket close the upper function close the upper function and give the space bar put the ampersand
02:34give the space type lower and open the bracket type mid open the bracket and select the cell
02:48comma type 2 type 2 type 2 comma type length which is the length open the bracket and select the cells
03:04and close the formula with three times bracket and hit enter and here you can see that only the first letter
03:13is capitalized and drag it and here all the other names are first letter is capitalized so with these four
03:24method you can easily auto capitalize first letter in excel if you think this video is helpful please support
03:31my channel thanks for watching
Comments