Excel SUBSTITUTE

Reverse Concatenate Formula in Excel

This post will guide youw how to reverse the concatenate function in Excel. how do I split the text string into the muliptle cells with a formula in Excel. How to split text data of a cell to multiple cells in Excel. Reverse Concatenate Formula To reverse concatenate formula in Excel, you can use a… read more »

Removing Dash Characters in Excel

This post will guide you how to remove all dash characters from a text string in one cell in Excel. How to remove dashes from social security numbers in a cell with a formula in Excel. Removing Dash Characters If you want to remove all dash characters in one cell in Excel, you can use… 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 »

Replace Last Comma in String with “and” word

This post will guide you how to replace last comma character in a string in cells with “and” word in excel. How do I replace the last comma character from a string with another word “and” using an excel formula. How to replace last instance of comma with ‘and’ in a string in excel. Replace… read more »

Sort List of Cells by Word Count

This post will guide you how to sort list of cells in excel by word count from the smallest to the biggest. How do I sort on word number of cells with a formula in a column in excel. Sort List of Cells by Word Count If you want to sort the list by word… 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 »

Remove Spaces from a String

This post will guide you how to remove extra spaces between words or text string from the specified range of cells in excel. How to delete all spaces from excel cells. For example, when you paste data from an external source to your current worksheet, and you must want to delete all the extra spaces,… read more »

Remove Leading and Trailing Spaces

In this tutorial you will learn that how to remove leading or trailing spaces from a text string in a cell in Excel. This post will guide you how to delete leading or trailing spaces of all cells in a column. If you remove leading spaces in cells one by one by manually, it will… read more »

How to Add a Character or Letter before Each Word in a Cell

This post will guide you how to add a specified character or letter before each word in a cell in excel. How to add a character to each word in a cell using excel formula. How to add a hash character before each word with a formula. Add a character or letter before each word… 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 »

Sidebar