SUBSTITUTE Function

How to Split String by Length in Excel (8 Ways)

If you are looking for some of the easiest ways to split string by length in Excel, then you are in the right place. So, let’s get started with this ...

How to Convert Text to Date in Excel (10 ways)

If you are looking for some of the easiest ways to convert text to date in Excel, then you will find this article useful. So, let’s dive into the ...

How to Compare Addresses in Excel (11 Easy Methods)

To perform any data analysis task comparing data in excel is common. It is most required for banks to check the background of a customer depending on ...

How to Remove Spaces in Excel: With Formula, VBA & Power Query

In Microsoft Excel, there are several effective methods available to remove all sorts of unwanted spaces. You’ll get to know all possible and ...

How to Add Space Between Text in Excel Cell (4 Easy Ways)

It is a common phenomenon in Excel that we import data from external sources. By doing so, we encounter entries void of spaces. In this article, we ...

How to Remove Blank Characters in Excel (5 Methods)

Excel is one of the most widely used applications in our professional life. We organize, calculate, manipulate our data using this Excel. In this ...

How to Remove White Space in Excel (6 Easy Ways)

While working in Excel, the extra space problem is a pretty common issue. In this article, you’ll learn how to remove white space in excel with some ...

How to Remove Specific Characters in Excel ( 5 Ways)

Sometimes our Excel datasheet contains unnecessary characters which we may want to remove. In this article, I’ll show you five easy and simple ways ...

How to Remove Non-Printable Characters in Excel (4 Easy Ways)

Every Character printable or non-printable bears a Unicode Character Code or Value. The First 32 characters (0-31) of Unicode or ASCII in programs to ...

Editor choice How to Remove Non-Printable Characters in Excel (4 Easy Ways)

How to Remove Specific Text from Cell in Excel (Easiest 11 Ways)

If you are looking for some of the easiest ways to remove specific text from a cell in Excel, then you will find this article worth it. While working ...

How to Remove Leading Spaces in Excel (4 Methods)

While creating a large worksheet it is very much possible to have some extra spaces in the contents. To make an excellent worksheet it is needed to ...

How to Remove Special Characters in Excel (4 Methods)

Many times the database contains some special characters which we do not need in the database and we want to remove them. We can easily perform this ...

How to Remove Text From Excel Cell (9 Easy Ways)

There are several methods to remove text from an Excel cell. In this article, I’ll show 9 methods including VBA to remove text from the Excel cells. ...

Excel Count Specific Characters in Cell (4 Quick Ways)

Sometimes we need to count only the specific characters in an Excel cell. Different excel functions make this easy for us. In the article, we are ...

How to Remove Characters in Excel (6 Methods)

While working with a large dataset, it is not a wise way to remove characters manually when needed. In this article, we will show you how to remove ...

ExcelDemy
Logo