Excel Formula to Capitalize First Letter #excelshorts

Excel Formula to Capitalize First Letter.

🍐Join my online course on Excel Tables

🍓Download my free eBook on Excel Macros

🍇Check these Books on Excel

🍉Read my articles on Excel

🍏Playlist for Shorts on Excel

#excelshorts #exceltip #exceltrick

[charleslakw]

Your short lessons are enlightening and show your extensive knowledge of Excel
Thank you for sharing your talents

[AVKC]

"Proper" formula gives similar result as this but, with less complexity. I am a fan of u r short Excel videos.

[ThejaswiS]

There is a separate formula “=Proper(A2)” for this

[arunvijayakumar]

Hi I keenly watch your channel. One suggestion. If you can explain the logic of the formula, it may be more easy to understand.

[Angel_Heart]

U can do it by =Proper formula that would have be more easy, short and simple

[LaureanoFulco]

Proper would capitalice every word, not just the first one.

[Epic_Sonia]

Sir is talking about only first letter in capital of a sentence
But proper () gives first letter in capital of every word in a sentence

[ajminxy]

I'm confused as to why the MID func is used here. Isn't the Proper function easier?

[gamingboyhindi]

better we should just copy paste and change first word for small amount of line

[Bishnurawal]

You are teaching In very complicated. Simply =proper(a2)

[rksingh]

Why to write such a big formula, when you have Proper function.

[mikey]

It would be quicker to just change the letter. Lol

[jennyrose]

Why not proper :( thanks for making it more complicated

[wisdom_stream]

No need for such a long formula
Anyone can simply type text in next cell in proper way and simple press down crtl+E

Crtl+E is the best shortcut know is flashfill(down) it work in 2013 excel and onward

[matroosoft]

You can use the PROPER() formula of it's only one word