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

How To Capitalize First Letter Of A Sentence In Excel?

In this tutorial I will show you how to capitalize first letter only within excel using Formula. This tutorial is really easy and I am doing this because one of my subscribers asked me to do so. You can ask me for tutorial also and I will try my best to answer.

I am using Microsoft Excel 2010 for this demonstration.
Let’s get started

Open the workbook you need to change. Now simple write this formula:

=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))

In an empty cell and press enter. Your text will be changed to something like this:

"YOU CAN CHANGE FROM UPPERCASE USING THIS FORMULA

You can change from uppercase using this formula"

Only first letter will be in uppercase and the rest will be in lowercase.

You can change any case with this formula. Hope this will helpful.

#excel10tutorial #capitalletter

Thanks for watching.

-------------------------------------------------------------------------------------------------------------
Support Us: patreon.com/excel10tutorial
-------------------------------------------------------------------------------------------------------------

If you like this tutorial, please subscribe:
goo.gl/uL8fqQ

Get the excel tutorial in PDF version here:
goo.gl/jkD9a5

Checkout our Advance Excel Tutorial Playlist:
goo.gl/ExYy7v

Checkout the Excel tutorial for dummies playlist: goo.gl/UDrDcA

If you need any specific tutorial you can request that here: goo.gl/jM78fA

Connect us on social media

Facebook: goo.gl/hdJ7rN

Google Plus: goo.gl/Yk4DQc *Become a member and enjoy exclusive perks while supporting the channel you love!*
youtube.com/@Excel10tutorial/join