Excel LEFT - 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 Remove Middle Name from Full Name in Excel

March 1, 2020

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 Convert Text to Time in Excel

September 27, 2019

This post will guide you how to convert time string to time in Excel. Assuming that you have a list of text string in your worksheet, and you wish to convert these time string to standard time format, how to do it. You need to use an formula based on the TIMEVALUE function, the LEFT… read more »

How to Extract Initials From a Name in Excel

August 19, 2019

This post will guide you how to get initials from a given name using a formula in Excel. How do I extract initials from names in Excel 2013/2016. Extract Initials from a Name Using a Formula Extract Initials from a Name Using User Defined Function Assuming that you have a list of data in range… read more »

How to Remove Last or Trailing Commas in Excel

August 13, 2019

This post will guide you how to remove trailing commas from cell in Excel. How do I remove comma character at the end of a cell with a formula in Excel 2013/2016. Remove Trailing Commas if you want to remove trailing commas from you Excel cells, and you can create a formula to check for… read more »

How to Filter Cells Starts with Number or Letter in Excel

June 21, 2019

This post will guide you how to filter values starts with number or letter in one single cell in Excel. How do I filter in a list those that begin with number or letter using a formula in Excel. Filter Cells Starts with Number or Letter Assuming that you have a list of data in… read more »

How to Convert mmddyy to Date in Excel

June 18, 2019

This post will guide you how to convert non-standard date formats or text to a standard date in Excel. If you have a date with mmddyy format, and you want to change it as the normal date format as mm/dd/yyyy with Excel Formula. How do I convert the mmddyyyy text to normal date format in… read more »

How to Convert Military Time to Standard Time in Excel

March 28, 2019

This post will guide you how to convert military time to standard time with a formula in Excel. How do I convert from military time 17:29:30 to regular time 5:29:30PM in Excel. How do I Convert Standard time to military time with a formula in Excel. Convert Military Time to Standard Time Convert Standard Time… read more »

How to Convert Julian Date to a Calendar date in Excel

February 1, 2019

This post will guide you how to convert Julian date to a calendar date in Excel. How do I convert a given Julian Date to a calendar date with a formula in Excel. What is Julian Date? Julian day number is the integer assigned to a whole solar day in the Julian day count starting… read more »

How to Remove the First/Last Word from Text string in Cell

January 28, 2019

This post will guide you how to remove the first and the last word from a text string in cells in Excel. How do I use a formula to remove first and last word of a text string in Excel. Remove the First Word from Text String Remove the Last Word from Text String Remove… read more »