Excel MID - Free Excel Tutorial - Part 2

Sort by Second or Third character in a Column

This post will guide you how to sort text string by second or third character in a Column in Excel. You may be want to sort a string in a Cell by the Second or last character in excel, how to quickly do it? You can use the Excel Formula or Text to Column feature… read more »

How to Reverse First Name and Last Name

This post explains that how to flip or reverse the first name and last name in one column. How to reverse the first name and last name in each cell in one column in excel. How to flip the first name and last name with excel formula or excel VBA macro. If you need to… 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 »

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 extract nth word from text string

This post will guide you how to extract the nth word from a text string in excel. How do I get the nth word from text string in a cell using excel formula. How to write a User Defined Function to extract nth word from text. Extract nth word If you want to extract the… 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 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 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 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 Extract Text between Commas

This post will guide you how to extract text between commas in excel. Before we talked that how to extract text between brackets using a formula with MID and SEARCH functions. And this post will extract text between commas instead of brackets. The biggest difference is that the brackets have the left and right, but… 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 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 »

How to Split Multiple Lines from a Cell into Rows

This post will guide you how to split multiple lines from a cell into separated rows or columns in Excel. You will learn that how to extract text string separated by line break character into rows in excel 2013. In the previous post, we talked that how to split text string by only one line… read more »

How to Extract Attribute Values from XML/HTML Data

This post will guide you how to extract attribute values from XML or HTML data in a range or cells in excel.  How to strip values from XML or other markup in excel Cells. Extract Attribute Values from XML Assuming that you have a table that contains the content of the markup language, such as:… 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 »

How to Split Text String to an Array

This post explains that how to convert the text to an Array in excel. How to convert text into array using formula in excel 2013? How to split the text string into an array where the each character in text is an element in array using excel formula in excel 2013. How to split text… read more »

How to remove non numeric characters from a cell

This post explains that how to remove non-numeric characters (numbers) from a text string in one cell in excel 2016. How to remove non numeric characters from a cell containing text string with an excel formula. And how to remove alphanumeric characters from a cell with a user defined function in excel VBA. Remove non… read more »

How to Remove Numeric Characters from a Cell

This post explains that how to remove numeric characters (numbers) from a text string in one cell in excel 2016. how to remove only numeric characters but keep the non-numeric characters from a cell containing text string with an excel formula. And how to remove numbers from a cell with a user defined function in… read more »

Sidebar