excel LEFT

How to remove first and last characters from text string

This post will guide you how to remove the first character from a text string using excel formula. How to remove the last character from string in Excel. How to remove the first x number of characters from a text string. How to delete the last x number of characters from string. Remove First Character… read more »

How to get first word from text string

This post will guide you how to extract the first word from a text string in excel. How to get the first word in a text using excel formula. Get First word If you want to extract the first word from a text string in a cell, you can use a combination of the IF… read more »

How to replace all characters before the first specific character

This post will guide you how to replace all characters before the first match of a specific character with a new text string in excel. How to replace substring before the first occurrence of the comma character with another substring in a text string using excel formula. Replace all characters before a specific character If… read more »

How to remove text after a specific character

We talked that how to remove all characters before the first match of the comma character in the previous post. And this post will teach you how to remove text after the first occurrence of the comma character in a text string in excel. Remove text after a specific character If you want to remove… read more »

How to extract text before first comma or space

This post explains that how to extract a substring before the first specific character, such as: comma or space character. How to get text before the first comma in a text string using a formula in excel. Extract text before first comma or space If you want to extract text before the first comma or… read more »

How to extract word that starting with a specific character

This post will guide you how to extract a word that starts with a specific character in excel. Extract word that starting with a specific character For example, Assuming that you have a text string that contains email address in Cell B1, and if you want to extract word that begins with a specific character… read more »

How to Convet Text Date dd/mm/yy to mm/dd/yyyy as Date Format

This post explains that how to convert text date in the format dd/mm/yy to the standard date format mm/dd/yyyy in excel. How to change dates in text format dd/mm/yy to mm/dd/yyyy as date format in excel 2013. Convet Text dd/mm/yy to mm/dd/yyyy as Date Format If you want to convert dates in the text format… read more »

Get First Name From Full Name

This post explains how to extract the First name from full name using excel formula. If you want to get the first name from a full name list in Column B, you can use the FIND function within LEFT function in excel. The generic formula is as follows: =LEFT(B1,FIND(” “,B1)-1) The full name is separated… read more »

Get Path and Workbook name only

Generally, the Cell function returns the full file name contain workbook and worksheet name and it is absolute path. If you want to get the workbook name and its path only without worksheet name, you can use a combination of the SUBSTITUTE function, the LEFT function, the CELL function and the FIND function. =SUBSTITUTE( LEFT(… read more »

Sidebar