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: / excel10tutorial
-------------------------------------------------------------------------------------------------------------
If you like this tutorial, please subscribe:
https://goo.gl/uL8fqQ
Get the excel tutorial in PDF version here:
https://goo.gl/jkD9a5
Checkout our Advance Excel Tutorial Playlist:
https://goo.gl/ExYy7v
Checkout the Excel tutorial for dummies playlist: https://goo.gl/UDrDcA
If you need any specific tutorial you can request that here: https://goo.gl/jM78fA
Connect us on social media
Facebook: https://goo.gl/hdJ7rN
Google Plus: https://goo.gl/Yk4DQc
Watch video How To Capitalize Only The First Letter Of A Sentence In Excel online without registration, duration hours minute second in high quality. This video was added by user Excel 10 tutorial 05 November 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 204,068 once and liked it 994 people.