SUBSTITUTE Function Archives - Page 15 of 17

How to Remove Text from a Cell in Excel (9 Easy Ways)

Feb 8, 2023

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 Excel cells. Just ...

How to Remove Text from a Cell in Excel (9 Easy Ways)

How to Count Specific Characters in a Cell in Excel (4 Quick Ways)

Feb 14, 2023

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 Count Specific Characters in a Cell in Excel (4 Quick Ways)

How to Remove Characters in Excel (6 Methods)

Feb 19, 2023

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

How to Remove Characters in Excel (6 Methods)

How to Remove the Trailing Spaces in Excel (2 Easy Ways)

May 31, 2023

We can easily remove unwanted characters or symbols from Excel if they are visible to us. But detecting and then deleting spaces is quite hard as ...

How to Remove the Trailing Spaces in Excel (2 Easy Ways)

How to Remove Characters from Left in Excel (6 Ways)

Mar 13, 2023

While working with Microsoft Excel, we can extract any number of texts from the beginning, middle, or end using functions and formulas. On the other ...

How to Remove Characters from Left in Excel (6 Ways)

How to Remove Dashes from Phone Number in Excel

Feb 19, 2023

In datasets, we come across phone numbers containing Dashes (-). For obvious reasons, we have to remove the dashes from the phone number entries. In ...

How to Remove Dashes from Phone Number in Excel

Extract Text Before Character in Excel (4 Quick Ways)

Dec 11, 2022

There are quite a few functions in Excel to extract text before the character quickly. In this article, we are going to know how to use them. ...

Extract Text Before Character in Excel (4 Quick Ways)

How to Remove Dashes in Excel (3 Methods)

Feb 14, 2023

Sometimes, we want to check certain values without dashes to have a deeper understanding of the information. But when the data are huge, it is not a ...

How to Remove Dashes in Excel (3 Methods)

How to Count Specific Words in a Column in Excel (2 Methods)

Apr 13, 2023

It's possible that the instance of a word in a text string repeats frequently. You might also be interested in counting the total number of ...

How to Count Specific Words in a Column in Excel (2 Methods)

How to Count Specific Characters in a Column in Excel

Feb 7, 2023 1

Microsoft Excel is a powerful tool for organizing, analyzing, and manipulating data. One useful feature of Excel is the ability to count specific ...

How to Count Specific Characters in a Column in Excel

How to Count Number of Specific Characters in a Cell in Excel

Feb 12, 2023

While dealing with MS Excel you might need to count the number of specific characters in a cell in Excel. There are several techniques to perform ...

How to Count Number of Specific Characters in a Cell in Excel

How to Count Number of Characters in a Cell in Excel (6 Ways)

Feb 28, 2023

If you are looking for some of the easiest ways to count the number of characters in a cell in Excel then you are in the right place. Sometimes it ...

How to Count Number of Characters in a Cell in Excel (6 Ways)

How to Remove Text After Character in Excel (4 Easy Ways)

Mar 6, 2023 2

While working with a large dataset, sometimes you may need to remove some certain parts of the data. To do this manually is really time consuming and ...

How to Remove Text After Character in Excel (4 Easy Ways)

How to Remove Space in Excel Before Numbers (3 Easy Ways)

Mar 7, 2023

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make ...

How to Remove Space in Excel Before Numbers (3 Easy Ways)

How to Repeat Rows for a Specified Number of Times in Excel

Feb 7, 2023 4

While working in Excel we may need to repeat rows a specific number of times. This happens when you are making bills for products or keeping records. ...