Excel MID

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 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 »

Sidebar