LOWER function in Excel

Excel TEXT functions return a number in a specified number format

How to create email address from name in Excel

To build email addresses using first and last names, you can use a formula that concatenates values, with help from the LOWER and LEFT functions as needed. See example below: Formula =LOWER(LEFT(first)&last)&”@domain.com” Explanation In the example shown, the formula in D5 is: =LOWER(LEFT(C5)&B5)&”@”&”acme.com” How this formula works For a name like “Tim Brown”, this formula… read more »

How to Capitalize first letter in a sentence in Excel

This tutorial shows how to capitalize first letter in Excel. In Microsoft office word it is called sentence case, in Excel to capitalize the first letter in a word or string, you can use a formula based on the LEFT, MID, and LEN functions. Formula =UPPER(LEFT(A1))&MID(A1,2,LEN(A1)) Explanation  In the example shown, the formula in C5 is:… read more »

Change Case: Uppercase, Lowercase, Propercase in Excel

How to convert text to capital letters and more in Excel Often times computer users find it difficult to change case in Excel. Imagine working on a huge volume of excel data and you need to convert a record to capital letters or the reverse. Boom! your stuck because it is not word document. We all… read more »