SUBSTITUTE function

8 Approaches to Remove Currency Symbol in Excel

There are different formats available for data in cells of Excel. We can apply them to a cell when we’re working with it. Currency format is one of ...

5 Tricks to Insert Comma Between Words in Excel

In this article, I'll show you three excellent methods how to insert comma between words in Excel. Furthermore, these strategies will allow you to ...

7 Easy Ways to Replace Text with Blank Cell in Excel

In this article, I'll show you three excellent methods on how to replace text with blank cell in Excel. Furthermore, these strategies will allow you ...

6 Easy Ways to Put Comma After 5 Digits in Excel

Every now and then we have to deal with a very large data entry. They may be the record of our social security card number, our driving license ...

6 Approaches to Remove Space After a Number in Excel

We often have to work transferring a lot of data from external sources to a spreadsheet. In doing so, our data can get mixed up with some unwanted ...

7 Easy Ways to Use Comma in Excel Formula

In our daily life sometimes we require to deal with a very large dataset where the number entry can also be very large. If they are too large ...

3 Quick Ways to Replace Text After Specific Character

Every now and then we may find ourselves in a situation where we want to replace a text with some specific character or word. We sometimes need to ...

11 Approaches to Compare Addresses in Excel

In this lesson, I'll demonstrate 11 effective approaches to compare addresses in Excel. Moreover, these techniques will enable you to solve the ...

3 Easy Ways to Find and Replace in Multiple Excel Files

Every now and then we have to deal with a very large-scale dataset in our practical life. Data sets can be in different datasheets of the same ...

7 Ways to Remove Letters from Cell in Excel

In Excel, we can easily remove letters from a cell. Using different functions, formulas, and built-in features, we can remove letters from the text's ...

ExcelDen
Logo