Fixing Improper Capitalization in Excel Using the Proper Function

[@LoriDevineRoberts]

Thank you so much! It was so hard to find an explanation of how to save the new data without losing my mind!

[@sumedharathnayaka2739]

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

[@annisabel964]

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

[@shongraham2386]

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

[@tosinadeniyi7660]

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

[@_ChronoAI]

RUclips was made for this Kind of Education 💖💖

[@jagannathshri5987]

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

[@happycubes7124]

You've saved me a ton of work. Thank you.

[@cnopus]

Very helpful and easy to understand.

[@stellaalle914]

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

[@taylorboe5518]

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

[@sonuarya495]

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

[@summer284]

Wow you explain SO well !

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

[@tanicwhisper0647]

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.

[@sankatamil8963]

Super....Crystal clear sir..

[@desisto007]

Thank you! That was pretty helpful!

[@rockstar696923]

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

[@saraayman7185]

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

[@byDsign]

Great info!

[@maddipatirenu7894]

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

[@ellenbushuf]

Thank you , you saved me an hour of typing

[@maricelzamora9424]

This helps me! I was looking for this video!

[@davidlelenguiyah9306]

Thanks I appreciate. I was really stuck.

[@kathyreese9373]

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

[@pricklypriya]

Thank you so much for the clear explanation

[@athulsindhu1666]

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

[@EvolvewithIsrael]

THANK YOU SO MUCH SIR. IT WORKED

[@vineetapm9082]

Most helpful video . Wow

[@AhmedEid-vz2uv]

you're a lifesaver, thank you!

[@BaylessConleyTV]

This was so useful, thank you!

[@HeidiJeanTwin]

Thank you sir!

[@preetichoudhary3651]

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

[@rajapatel6253]

Its amazing useful trick thank you so much brother

[@nandishroyal8579]

Thank u for ur information it's usefull

[@glisten_skin]

Awesome stuff.👍

[@adeyemoadebayo5223]

Thank you.

[@mktimes9358]

Very useful

[@zeydmohamed1889]

Thanks so much

[@godwinuche4669]

Very useful. Thanks 🙏

[@eseoseomoifo-egbeyon2158]

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

[@melodymusiccentre-oman7979]

Thank you

[@lyricism1595]

thanks man. appreaciated.

[@TheMercymerz]

Great tip! Thank you!

[@DioEltchapa]

Man, you're the best.

[@jayprak143]

Really helpful 🤝

[@lawrencekazibwe9751]

Thanks alot boss, very impressive

[@dohtyx]

OMG this is perfect huhuh... Thanks😘😘

[@megharohra7831]

Thankyou somuch!!

[@yashwantvishnu6956]

Brilliant 🤩

[@Mhmd06]

Nice.

[@HouseOfCraft-nw2eu]

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.

[@madhurimainkar1687]

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 ?

[@rasmayarai185]

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

[@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?

[@sevenLP]

million thanx!!

[@jamesfarnham1976]

Like this. Thanks!

[@dannguyen239]

great!

[@Alton7771]

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

[@samueldevries4637]

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

[@thurston383]

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

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

[@kellyoku]

Great? thanks

[@gaurabbose5396]

wow

[@kanhaiyathakur1876]

Anybody know the shortcut command of proper fomula

[@zaksav]

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

[@fabulouspenn]

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)

[@gilly5809]

Wish there was a way to just select a column to set a rule for proper automatically without these formulas

[@azicogaming8270]

0:57, 3:18

[@jugilykajessa8477]

☺👍

[@PointerBro]

Forgot "Title" in A1

[@jephrygultiano6952]

Why a million times it will not work 😔

[@lemansabirli8069]

Thank you very much❤

[@Mohamed-Mansour8111]

Thank you so much

[@nabilakkar5315]

Thanks a lot

[@bluebird7745]

Thank you