Excel LOWER - Free Excel Tutorial

How to Convert Uppercase to Lowercase Except the First Letter in Excel

July 1, 2020

In excel, words can be entered in uppercase, lowercase or mixed. If we want to convert all uppercase to lowercase (except the first letter in some situations), we can use formula with some letter convert related functions to convert them to proper case. This article will introduce you some methods to convert letters from uppercase… read more »

How To Force Text String to Upper,Lower, or Proper Case in Excel

May 10, 2020

This post will guide you how to force test strings to uppercase or lowercase or Proper cases through an Excel formula or data validation in your Excel 2013/2016. How to convert text to upper, lower, or proper case in Excel. Assuming that you want to force text strings to Upper case when you type words… read more »

How to Remove Middle Name from Full Name in Excel

March 7, 2022

When we get a list of full names, we can remove the middle name for short in some cases. As the middle names are different among the full name list so we cannot replace them by space directly in excel. This article will provide you two methods to remove the middle name. User can use… read more »

How to Check If a Cell is Uppercase, Lowercases or Capitalize in Excel

January 21, 2019

This post will guide you how to check if a cell is uppercase in Excel 2013/2016. How do I identify all letters in cells are lowercases or capitalize in Excel. How to change letters to uppercase, lowercases or capitalize first letter for all words in cells in Excel. Check If All Letters are Uppercase Check… read more »

Change Uppercase and Lowercase Text

June 11, 2018

This post will guide you how to change the case of text to uppercase or lowercase in Excel. How do I change all uppercase text to lower case with an Excel formula. For example, if you want to change all text string in uppercase into lowercase, you can create a formula based on the Lower… read more »

Excel Lower Function

June 11, 2018

This post will guide you how to use Excel LOWER function with syntax and examples in Microsoft excel. Description The Excel LOWER function converts all characters in a text string to lowercase. The LOWER function is a build-in function in Microsoft Excel and it is categorized as a Text Function. The LOWER function is available in Excel 2016, Excel 2013, Excel 2010, Excel… read more »