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.

-------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------

If you like this tutorial, please subscribe:

Get the excel tutorial in PDF version here:

Checkout our Advance Excel Tutorial Playlist:

Connect us on social media

[Exceltutorial]

You don't need to write formula in column B, it will Automatically converted In Column A. If you follow this 👆 👆👆Tutorial

[jincysam]

Thank-you so much that was very helpful

[nikidcruz]

Wow . thank u soo much. very helpful since u had the formula left in the description

[AshishKumar-hckm]

Aise vedio kabhi nhi dekha
Very helpful

[dougmoreable]

This is all great but how do you do it when you have blank spaces in-between your data and you want to skip it?

[pattilasujit]

Here we get two columns one the corrected one and the other uncorrected one but how to delete the uncorrected one, in case we are trying to delete the uncorrected one both columns are being deleted, so please help me out from this problem

[praveenkrishnan]

How can I delete the unwanted column and just keep the reworked data?!

[harshkureel]

How to change in the same column not in other column

[duhhuaabbas]

After the work of the first letter in the text is done. How to delete the unfixed text without any change in the sheet??

[emmanbhattieb]

how can I lower case the second words first letter only?

[arslanakram]

I think =Upper(Left(A1, 1, 2, 3, 4, 5)) please tell me is it Right you can make a video if I'm right

[kingofheartsxyz]

how to format this in a way that when someone types it automatically changes the cells to uppercase ? for example if someone wants to types yes .. it should record in that cell as Yes

[atulgupta]

How to change all small words or sentences in capital letter

[arslanakram]

Hey are if you seeing this please make a video on how to capitalize every word first letter in Excel if possible please make it if not possible please reply

[lenns_music]

What formula can I use for the first and second word in a sentence to be upper case in excel?
Example: John Smith would like to learn to drive.
Thanks

[coolfire]

I wanted to write like this
*Brown Fox Jumps Over The Lazy Dog*

[jimmieecreationsbhai]

the word which is "john smith mayer" it is to be converted as "John smith mayer" in the first word "J "should be capital, we need to capitalize first letter only excel using formula only