This video was what I was looking for .... its like you read my mind ..... Thank you thank u u 😊😊
@tanicwhisper0647
5 жыл бұрын
I have a question, and if you answer it I’d truly appreciate it. How did you learn to utilize Words programs? Who did you learn from? Or was it all just you experimenting with the tools? Did you read updates? Did you follow the people who programmed it. Exactly what did you do to get yourself informed.
@taylorboe5518
2 жыл бұрын
Every video never mentioned that if you wanted to delete the original column, you have paste as values and not normal since it will give errors. Nice touch adding that
@sumedharathnayaka2739
Жыл бұрын
This gentleman who presented this lesson is doing very clearly, simple English for understanding to everyone. Thank you sir 🙏🙏
@jagannathshri5987
5 жыл бұрын
I have only word to say "Fantastic". Thank you so much for your lessons.
@shongraham2386
9 ай бұрын
u are the bessssssst excel teacher everrrrrrr!!!!!!!! subscribing NOW!!!!
@leonelriera5649
Жыл бұрын
Isn't there a way to apply that function to the cell itself instead of using two columns and going through all this? Eg: I write jhOn DOE in cell A1 and it automatically formats to John Doe. I mean, should be pretty simple as it's so obvious...
@byDsign
5 жыл бұрын
Great info!
@mahmoedi
Жыл бұрын
Hi, I think I'm missing some setting in my excel because when I do what you said, I get a copy of the same text in next row as the row I was working on. Can you tell me what I'm missing?
@rockstar696923
5 жыл бұрын
Very cool, very clear am enjoying the videos. Thanks for taking the time to post these.
@HouseOfCraft-nw2eu
4 ай бұрын
can we not replace directly on the range text that is gonna to be done proper? instead of having to insert column, do proper function and copy paste which is quite hassle.
@saraayman7185
2 жыл бұрын
thank you so much, this was very helpful and well explained
@samueldevries4637
4 ай бұрын
Water ship down in the family category is gonna ruin someone's childhood lol
@_ChronoAI
5 күн бұрын
KZitem was made for this Kind of Education 💖💖
@thurston383
Жыл бұрын
Can you not make it so a group of cells automatically capitalises words?
@Mhmd06
4 жыл бұрын
Nice.
@cnopus
Жыл бұрын
Very helpful and easy to understand.
@SJ-ty5vx
Жыл бұрын
Thanks for the video, solved what I needed to fix. Suggestion though, instead of selecting the entire column B to copy, I just selected the range of cells with the new proper text, so I didn't put blanks in my table headers. Unfortunately, you lost your A1 cell that said "Title" because your B1 was blank.
@dohtyx
Жыл бұрын
OMG this is perfect huhuh... Thanks😘😘
@kathyreese9373
5 жыл бұрын
This is great information! Thank you for posting this video.
@stellaalle914
2 ай бұрын
Thank you very much,you're the best teacher😊
@sonuarya495
2 жыл бұрын
Superb It's an easy trick to learn, I'm really glad after watching this video
@davidlelenguiyah9306
5 ай бұрын
Thanks I appreciate. I was really stuck.
@preetichoudhary3651
2 жыл бұрын
Thanks a lot i would apply this formula but always faced the same problem...finally i came to know how properly apply this formula
@Alton7771
4 жыл бұрын
This excel Book was written my Margo Roth Spiegelman I hope some on get this reference.
@desisto007
2 ай бұрын
Thank you! That was pretty helpful!
@madhurimainkar1687
3 жыл бұрын
while using PROPER Function once done with the capitalization in the existing spreadsheet merely copying and pasting special "only values" instead of formula from the new corrected column to old incorrect one ,would behave the same way if any new data is appended to the spreadsheet ? or do we have to repeat the earlier PROPER process to correct the added data ?
@eseoseomoifo-egbeyon2158
4 жыл бұрын
Thanks for sharing. Please how do I make them all uppercase or lowercase?
@tosinadeniyi7660
Жыл бұрын
This is the most useful video I've ever watched on KZitem. Thank you so much!
@EvolvewithIsrael
6 ай бұрын
THANK YOU SO MUCH SIR. IT WORKED
@rasmayarai185
2 жыл бұрын
thank you. was stuck whole day until i found this vide i was free.
@kanhaiyathakur1876
4 жыл бұрын
Anybody know the shortcut command of proper fomula
@rajapatel6253
3 жыл бұрын
Its amazing useful trick thank you so much brother
@gaurabbose5396
5 жыл бұрын
wow
@athulsindhu1666
2 жыл бұрын
Thank you for helping me sir❤️❤️❤️🥰
@happycubes7124
Ай бұрын
You've saved me a ton of work. Thank you.
@maricelzamora9424
2 жыл бұрын
This helps me! I was looking for this video!
@maddipatirenu7894
2 жыл бұрын
I really needed this. Good Explanation. Thank you for uploading.
@ellenbushuf
3 ай бұрын
Thank you , you saved me an hour of typing
@jamesfarnham1976
5 жыл бұрын
Like this. Thanks!
@Mohamed-Mansour8111
2 жыл бұрын
Thank you so much
@BaylessConleyTV
2 жыл бұрын
This was so useful, thank you!
@pricklypriya
2 жыл бұрын
Thank you so much for the clear explanation
@lyricism1595
2 жыл бұрын
thanks man. appreaciated.
@lemansabirli8069
Жыл бұрын
Thank you very much❤
@melodymusiccentre-oman7979
Жыл бұрын
Thank you
@dannguyen239
5 жыл бұрын
great!
@nandishroyal8579
2 жыл бұрын
Thank u for ur information it's usefull
@lawrencekazibwe9751
2 жыл бұрын
Thanks alot boss, very impressive
@azicogaming8270
3 жыл бұрын
0:57, 3:18
@jephrygultiano6952
Жыл бұрын
Why a million times it will not work 😔
@AhmedEid-vz2uv
2 жыл бұрын
you're a lifesaver, thank you!
@megharohra7831
11 ай бұрын
Thankyou somuch!!
@glisten_skin
4 ай бұрын
Awesome stuff.👍
@HeidiJeanTwin
2 жыл бұрын
Thank you sir!
@zeydmohamed1889
2 ай бұрын
Thanks so much
@adeyemoadebayo5223
2 ай бұрын
Thank you.
@vineetapm9082
2 жыл бұрын
Most helpful video . Wow
@jugilykajessa8477
5 жыл бұрын
☺👍
@nabilakkar5315
2 жыл бұрын
Thanks a lot
@mktimes9358
Жыл бұрын
Very useful
@yashwantvishnu6956
Жыл бұрын
Brilliant 🤩
@sankatamil8963
Жыл бұрын
Super....Crystal clear sir..
@PointerBro
3 жыл бұрын
Forgot "Title" in A1
@godwinuche4669
2 жыл бұрын
Very useful. Thanks 🙏
@summer284
Жыл бұрын
Wow you explain SO well !
@zaksav
4 жыл бұрын
what do u do when u want all text in CAPITALS?
@fabulouspenn
3 жыл бұрын
You can use the function =UPPER (B2) B2 is just the column you want to convert. The rest is the same (i.e to copy and paste specials)
Пікірлер: 74