excel function

How to combine columns without losing data

This post will guide you how to merge and combine multiple columns without losing any data in excel. How do I merge columns without losing data using Excel Formula. For example, you want to join two columns that contain first name and last name into one column without losing data. If you want to merge… read more »

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 remove unwanted characters from text string

This post explains that how to remove unwanted characters from text string in a Cell in Excel. How do I remove unwanted characters from a cell using Excel formula. Remove Unwanted Characters If you want to remove unwanted or specified characters from a text string, you can create an excel formula based on the SUBSTITUTE… 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 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 count the number of line breaks in a cell

This post explains that how to count the number of line breaks in a cell using excel formula. How do I count line breaks in a single cell in excel. In the previous post, we talked that how to count specific words in a cell and this post will guide you how to count line… read more »

How to count the number of words in a cell in Excel

This post explains that how to count the number of words in a cell using excel formula. How to count total words in a cell with User Defined Functions in excel VBA. Count the number of words in a cell If you want to count the number of words in a single cell, you can… read more »

How to count specific words in a cell or a range in Excel

This post explains that how to count the number of a specific word in a cell or a range of cells in excel. This post will guide you how to count specific words in a single cell or a range using excel formula. How to count the occurrence of a specific word in a cell… read more »

Sidebar