Excel: Capitalize First Letter of Each Word in a Cell

Is there any way to do this with only using 1 column and have the proper function work after you've typed in the word to capitalize the first letter?

Thank you.

there is button in toolbar in some versions, how can i find it ?

nice work

Thanks u saved my time sir, blessing from Somalia 🇸🇴

Perfect! Thank you!

This helps me a lot. Thank you so much.

Very helpful and simple, thank you

thank you so much…it works like magic

Thanks Chester, saved me an age!

Love the explanation! SNAFU, How do I keep the now capitalized row, and delete the old non capitalized one without screwing up the reference cell?

I rarely post comments, but I've been looking for a way to do that and couldn't find anything for weeks. Thank you so much for the clear and simple explanation!

If the name does not have space e.g tomsmith how can we capitalise first letter of each word

Thanks for this Chester. Saved me correcting data entries from lazy students.

Thank you kindly...

Thanks!

Is This Why People Type Comments Like This, Because They Work In Excel So Much, They Don't Even Realize They Type Like This?

I turned on Capitalize the first letter of sentences in Options but it didn't work. Can you help me? Thank you

Thank you.

Sooo helpfull thank youuu

So easy !!! I cannot believe it. Love you !

thanks a lot.

Can you do this if there are numbers in the cell? For Example A123, b123, c123, D123? and you need to capitalise them?