Excel: Capitalize First Letter of Each Word in a Cell

Подписаться 100 тыс.

Просмотров 177 тыс.

50% 1

In this video I demonstrate how to capitalise the first letter of each word in a cell. This might be useful where you have first name, last name in a cell and you need to correct case.
The first method I demonstrate uses Flash Fill - a feature that appears in more recent versions of Excel. The second method I demonstrate uses the PROPER function which is available in all versions of Excel.
This video will be useful if you have the following queries:
How do you capitalize first letter?
What's it called when you capitalize the first letter of each word?
How do you capitalize words in Excel?
Excel uppercase first letter of first word.
How to change first letter to uppercase in Excel?
------------------------

Хобби

Опубликовано:

20 янв 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 32

@MrFloKop Год назад

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!

@mohamedosman2431 Год назад

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

@danielmaserrat5060 7 месяцев назад

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?

@LesIgnou57 2 года назад

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

@engosamadawood Год назад

Very helpful and simple, thank you

@sharvinipriyaravichandar4981 Год назад

thank you so much…it works like magic

@ampedpcr Год назад

Thanks Chester, saved me an age!

@moldakotabees 2 года назад

Sooo helpfull thank youuu

@PlayerLeonardo 5 месяцев назад

Thanks, it helped me a lot and I used the Flash Fill feature ;)

@faxandscan 2 года назад

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

@simplysensy 2 года назад

Thank you.

@hemalwatts9627 2 года назад

thanks a lot.

@avivacglobalventure9487 2 года назад

Thanks!

@ammarkhadim6705 2 года назад

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

@mr.r1234e 5 месяцев назад

Thank you so much!

@jeansade___ Год назад

This helps me a lot. Thank you so much.

@ChesterTugwell Год назад

Glad it helped!

@echorider Год назад

Perfect! Thank you!

@ChesterTugwell Год назад

Glad it helped!

@halilnevzat Год назад

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

@amyknapp8952 3 года назад

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

@leelfm 2 года назад

Yes the proper function works for that.

@linhthuy2740 2 года назад

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

@SALEENS7GTR5 2 года назад

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

@bulldogkarma 4 месяца назад

I like the proper method but after I Completed that task I deleted the column no longer needed but then it deleted the column that I was entering in the new proper formula.

@mariek2070 Год назад

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?

@hopelessdecoy Год назад

Pretty sure you can just cut and paste the new values into the old column

@morgangallant2811 Год назад

That won't work, your new column only exists as a copy as the original, if you delete the old one the new one is also deleted, if there's a way to do so that would be great