Fixing Improper Capitalization in Excel Using the Proper Function 

This gentleman who presented this lesson is doing very clearly, simple English for understanding to everyone. Thank you sir 🙏🙏

u are the bessssssst excel teacher everrrrrrr!!!!!!!! subscribing NOW!!!!

This video was what I was looking for .... its like you read my mind ..... Thank you thank u u 😊😊

I have only word to say "Fantastic". Thank you so much for your lessons.

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

Very cool, very clear am enjoying the videos. Thanks for taking the time to post these.

This is the most useful video I've ever watched on RU-vid. Thank you so much!

I really needed this. Good Explanation. Thank you for uploading.

This is great information! Thank you for posting this video.

Thank you very much,you're the best teacher😊

thank you so much, this was very helpful and well explained

Wow you explain SO well !

Thank you , you saved me an hour of typing

Very helpful and easy to understand.

Great info!

Great tip! Thank you!

Thank you so much for the clear explanation

This was so useful, thank you!

This helps me! I was looking for this video!

you're a lifesaver, thank you!

Very useful. Thanks 🙏

Thanks I appreciate. I was really stuck.

Man, you're the best.

Thank you sir!

Super....Crystal clear sir..

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.

THANK YOU SO MUCH SIR. IT WORKED

Really helpful 🤝

Its amazing useful trick thank you so much brother

Thank you very much❤

Thanks alot boss, very impressive

Awesome stuff.👍

Like this. Thanks!

thanks man. appreaciated.

Thank u for ur information it's usefull

Superb It's an easy trick to learn, I'm really glad after watching this video

Thank you so much

Most helpful video . Wow

Thanks a lot

Thank you for helping me sir❤️❤️❤️🥰

Thankyou somuch!!

Very useful

Thank you.

million thanx!!

Thank you

OMG this is perfect huhuh... Thanks😘😘

Brilliant 🤩

Thanks a lot i would apply this formula but always faced the same problem...finally i came to know how properly apply this formula

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.

great!

Nice.

Thanks for sharing. Please how do I make them all uppercase or lowercase?

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 ?

thank you. was stuck whole day until i found this vide i was free.

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.

Great? thanks

This excel Book was written my Margo Roth Spiegelman I hope some on get this reference.

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?

Water ship down in the family category is gonna ruin someone's childhood lol

wow

Anybody know the shortcut command of proper fomula

Can you not make it so a group of cells automatically capitalises words?

what do u do when u want all text in CAPITALS?

0:57, 3:18

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...

☺👍

Forgot "Title" in A1

Why a million times it will not work 😔

Thank you