In this tutorial, I will show you how to capitalize the first letter only in Excel using Formula. This tutorial is really simple and I'm doing it because one of my subscribers asked me. You can also ask me for a tutorial and I will do my best to answer it.
I am using Microsoft Excel 2010 for this demonstration.
Let's get started
Open the workbook you need to edit. Now just write this formula:
UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))
In an empty cell and press Enter. Your text will be modified as follows:
/"YOU CAN CHANGE YOUR CAPITAL LETTER USING THIS FORMULA
You can change the capital letters using this formula /"
Only the first letter will be uppercase and the rest will be lowercase.
You can modify any case with this formula. I hope this will be useful.
#excel10 tutorial #lettrecapitale
Thank you for watching.
————————————————– ————————————————– ———
Support us: https://www.patreon.com/excel10tutorial
————————————————– ————————————————– ———
If you like this tutorial, subscribe:
https://goo.gl/uL8fqQ
Get the Excel tutorial in PDF version here:
https://goo.gl/jkD9a5
Check out our Advance Excel Tutorial Playlist:
https://goo.gl/ExYy7v
Check out the Excel for Dummies tutorial playlist: https://goo.gl/UDrDcA
If you need a specific tutorial, you can request it here: https://goo.gl/jM78fA
Connect with us on social media
Facebook: https://goo.gl/hdJ7rN
Google Plus: https://goo.gl/Yk4DQc
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments