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.
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
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...
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?
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.
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.
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 ?
This video was what I was looking for .... its like you read my mind ..... Thank you thank u u 😊😊
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.
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
This gentleman who presented this lesson is doing very clearly, simple English for understanding to everyone. Thank you sir 🙏🙏
I have only word to say "Fantastic". Thank you so much for your lessons.
u are the bessssssst excel teacher everrrrrrr!!!!!!!! subscribing NOW!!!!
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...
Great info!
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?
Very cool, very clear am enjoying the videos. Thanks for taking the time to post these.
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.
thank you so much, this was very helpful and well explained
Water ship down in the family category is gonna ruin someone's childhood lol
TH-cam was made for this Kind of Education 💖💖
Can you not make it so a group of cells automatically capitalises words?
Nice.
Very helpful and easy to understand.
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.
OMG this is perfect huhuh... Thanks😘😘
This is great information! Thank you for posting this video.
Thank you very much,you're the best teacher😊
Superb It's an easy trick to learn, I'm really glad after watching this video
Thanks I appreciate. I was really stuck.
Thanks a lot i would apply this formula but always faced the same problem...finally i came to know how properly apply this formula
This excel Book was written my Margo Roth Spiegelman I hope some on get this reference.
Thank you! That was pretty helpful!
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 ?
Thanks for sharing.
Please how do I make them all uppercase or lowercase?
This is the most useful video I've ever watched on TH-cam. Thank you so much!
THANK YOU SO MUCH SIR. IT WORKED
thank you. was stuck whole day until i found this vide i was free.
Anybody know the shortcut command of proper fomula
Its amazing useful trick thank you so much brother
wow
Thank you for helping me sir❤️❤️❤️🥰
You've saved me a ton of work. Thank you.
This helps me! I was looking for this video!
I really needed this. Good Explanation. Thank you for uploading.
Thank you , you saved me an hour of typing
Like this. Thanks!
Thank you so much
This was so useful, thank you!
Thank you so much for the clear explanation
thanks man. appreaciated.
Thank you very much❤
Thank you
great!
Thank u for ur information it's usefull
Thanks alot boss, very impressive
0:57, 3:18
Why a million times it will not work 😔
you're a lifesaver, thank you!
Thankyou somuch!!
Awesome stuff.👍
Thank you sir!
Thanks so much
Thank you.
Most helpful video . Wow
Thanks a lot
☺👍
Very useful
Brilliant 🤩
Super....Crystal clear sir..
Forgot "Title" in A1
Very useful. Thanks 🙏
Wow you explain SO well !
what do u do when u want all text in CAPITALS?
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)
Man, you're the best.
million thanx!!
Great tip! Thank you!
Really helpful 🤝
Thank you
Great? thanks