Excel SEARCH - Free Excel Tutorial

If Cell Contains Certain Text OR Equals Certain Text

IF cell equals certain text IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to test values to see if they equal certain text like “abc”, you can build formula with IF function to return result. FORMULA To test if… read more »

How to Extract Text between Two Text Strings in Excel

This post will guide you how to extract text between two given text strings in Excel. How do I get text string between two words with a formula in Excel. Extract Text between Two Text Strings Assuming that you have a list of data in range B1:B5, in which contain text string values. And you… read more »

How to Return a Value If a Cell Contains a Specific Text in Excel

This post will guide you how to return a value if a cell contains a certain number or text string in Excel. How do I check if a Cell contains specific text and then return another specific text in another cell with a formula in Excel. Return Value If Cell Contains Certain Value Video: Return… read more »

Insert The File Path and Filename into Cell

This post will guide you how to insert the file path and filename into a cell in Excel. Or how to add a file path only in a specified cell with a formula in Excel. Or how to add the current workbook name into a cell in Excel. How do I insert the current worksheet… read more »

Sort Cells by Specific word or words

This post will guide you how to sort cells or text values in a column based on a specific word even if the word is in the text string in the cell. How do I sort cells in a column by the number of a specific word or words in excel. Sort Cells by Specific… read more »

Highlight Rows

This post will teach you how to highlight rows in a table with conditional formatting in Excel. You will learn that how to change the color of the entire rows if the value of cells in a specified column meets your conditions, such as, if the value of cells is equal to or greater than… 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 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 »

Check if Cell Contains Certain Values but do not Contain Others Values

In the previous post, we only talked that how to check a cell if contains one of several values from a range in excel. And this post explains that how to check a cell if it contains certain values or contains one of several values but do not contain other certain values in another range… read more »

How to get last match that cell contains one of several values in a range

This post explains that how to check a cell that contains one of several values in another range, and then return the last match value.  And we talked that how to test a cell to see that if it contains one of several values in a list in the previous post. And this post will… read more »

How to get first match that cell contains one of several values in a range

This post explains that how to get the first match that cell contains one of several values from another range or a list in excel. before we talked the way that how to check a cell to see that if it contains one of several values in a range or list using the SEARCH function… read more »

How to Extract Text between Parentheses

This post explains that how to extract text between the parentheses using the formula in excel. Extract text between parentheses If you want to extract text between parentheses in a cell, then you can use the search function within the MID function to create a new excel formula. For example, to extract data between parentheses… read more »

How to Extract Text between Brackets

We talked that how to extract data between parentheses in the previous post, and this post will guide you how to create similar formula to extract text between brackets in a cell. Extract text between brackets If you want to extract text between brackets in a cell, you need to create a formula based on… read more »

How to check if Cell contains one of many values from range

In the previous post, we talked that how to check if cell contains all of values from a list in excel, and this post will guide you how to test a cell if it contains one of several values in a range or a list in excel. How to check that at least one value… read more »

How to Check If Cell Contains All Values from Range

This post explains that how to check if a cell contains all of several values from a range in excel. How to check if cell contains all of many values in a list in excel 2013. How to check if all of values in a list can be found in a cell, if TRUE, then… read more »

How to get the position of Last Occurrence of a character or string in a cell

In the previous post, we have talked that how to get the position of the last occurrence of a specific value in a single range or column. And this post will guide you how to get the position of the last occurrence of a character or text string in a Cell using below two ways… 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 »

Split Text String by Specified Character in Excel

This post explains how to split text string by a specified character (such as: comma, space, dash, slash, etc.) using FIND function within other functions in excel. And you will learn that how to extract part of characters to the left of a specified character in one cell. Split Text String by Specified Character When… read more »

Sidebar