How To Capitalize Only The First Letter Of A Sentence In Excel Automatically

preview_player
Показать описание
Learn to Capitalize Only the First Letter of a Sentence in Excel Automatically
But now in this video I’ve fully automated the whole process. I’ve created a VBA in a way so that it will convert the sentence as you type. It means you type your sentence in whatever case you like, but when you press enter the sentence will be converted in a way that only the first letter will be in uppercase and the rest of the sentence will be in lowercase. The procedure is as follows:
Step 1: Right-click on the worksheet tab
Step 2: Click on view code.
Step 4: Close the VBE (Visual Basic Editor)
Done.

#FirstLetter #Capitalize #SentenceCase

-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:
Рекомендации по теме
Комментарии
Автор

It’s working bro
Thank you very much

nagaganapathi
Автор

How can I find the code.
And where to sign app. I can't see it. Pls

Abdirahman
Автор

Code to capitalise first letter of every word...

ravindravhandarao
Автор

Code for capitalize evry first letter of word of sentence

rishitsoni
Автор

where is cod please ??where is cod please ??where is cod please ??where is cod please ??

samanmaeruf
Автор

you are too fast man! too fast! im not sure if i got your tip

clevermachingura