Excel Find - Free Excel Tutorial - Part 2

How to Count Spaces before the Text String

This post will guide you how to count the number of spaces before the text string in a cell in Excel. How to count the leading spaces before the text string in one cell with formula in excel. How do I create an excel formula that counts the number of spaces before the text string…. read more »

Sort Name by Last Name in Excel

This post will guide you how to sort full name by last name in excel. How to sort full names by last name using Text to Columns command in excel. How do I sort names by last name with excel formula. Sort Names by Last Name using Excel Formula Assuming that you have a list… read more »

Sort Names by Middle Name in Excel

This post will guide you how to sort full name by middle name in excel 2013, or 2016. How do I sort names by middle name with excel formula. How to sort full names by middle name using Text to Columns command in excel. Sort Names by Middle Name using Excel Formula Assuming that you… read more »

How to remove all spaces between numbers or words

This post will describe two quick ways to remove all space characters between numbers or words in excel. How to remove unwanted spaces from cells in a select range of cells in Excel. Assuming that you have a list of data with text string and numbers in one cell, and you want to remove all… read more »

Split full name to first and last name

This post will guide you how to split the full name to the first name and last name in the different cells in excel. How to create an excel formula to split the full name to first name and last name. How to get the middle name from the full name string using a formula…. 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 get last word from text string

This post explains that how to extract the last word from a text string in excel. How do I get the last word in a text string using excel formula. Extract last word If you want to get the last word from a text string, you can create an excel formula based on the RIGHT… read more »

How to extract word that containing a specific character

This post will guide you how to extract word that containing a specific character using formula in excel. How to get a word that contains a specific character (such as: @, comma, hash, etc.) in a text string in one cell. Extract word that containing a specific character If you want to extract word that… read more »

How to replace all characters after the first specific character

This post will guide you how to replace all characters after the first match of a specific character with a new text string in excel. How to replace all substrings after the first occurrence of the comma character with another substring in a text string using excel formula. How to replace all old_text with new_text… 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 remove text before the first match of a specific character

This post explains that how to remove text before the first occurrence of the comma character in a text string in excel. How to remove all characters before the first match of the comma or others specific characters in excel. Remove text before the first match of a specific character If you want to remove… read more »

How to extract text after the second or nth specific character (space or comma)

In the previous post, we talked that how to extract text after the first occurrence of the comma character in excel. And this post explains that how to get a substring after the second or nth occurrence of the comma or space character in excel. Extract text after the second or nth specific character If… read more »

How to extract text before the second or nth specific character (space or comma)

Before we talked that how to extract text before the first space or comma character in excel. And this post will guide you how to extract a substring before the second or nth specific character, such as: space or comma character in excel. Extract text before the second or nth specific character If you want… read more »

How to extract text after first comma or space

In the previous post, we talked that how to extract substring before the first comma or space or others specific characters in excel. And this post will guide you how to extract text after the first comma or space character in a text string. Extract text after first comma or space If you want to… 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 Get the Position of the nth Occurrence of a Character in a Cell

In the previous post ,we talked that how to get the position of the last occurrence of a character in a cell, and sometimes, you may be want to know the position of the 2th, 3th or nth occurrence of a character in a text string in excel. and this post will guide you how… read more »

Get Last Name From Full Name

This post will guide you how to extract the last name within a Full name in excel. You need to use a combination of the RIGHT function, the LEN function, the FIND function and the SUBSTITUTE function to create a complex formula in excel. Get Last Name From Full Name You can use the below… read more »

The different between FIND and SEARCH functions

There are two big differences between FIND and SEARCH functions in excel. The FIND function is case-sensitive. And the SEARCH function is case-insensitive. The FIND function is not allow to use wildcard. But the SEARCH function is allow to use wildcard characters.  The FIND function is case-sensitive If you want to locate the position of… read more »

Sidebar