Sentence case, lowercase and uppercase in Excel tutorial

This is a quick tutorial on how to change text to sentence case, lowercase and uppercase in Microsoft Excel. Change you text to sentence case with this function (assuming your text is in cell A1):


=PROPER(A1)

Change you text to uppercase with this function (assuming your text is in cell A1):
=UPPER(A1)
Change you text to lowercase with this function (assuming your text is in cell A1):
=LOWER(A1)
 That's it, enjoy!

1 comment:

  1. It is all clear now. But what if there you colud not open csv file, what to do then? I found the solution with how to open csv file https://wikiext.com/csv in case what if... Maybe for some one this information will be useful. Because at first time, I try to restart twice the app, and nothing gonna work, untill I found this.

    ReplyDelete