SUBSTITUTE Function

How to Truncate Spaces in Excel (5 Easy Methods)

Excel provides a wide-ranging utility to its customers. Sometimes your work demands to truncate spaces in our data. In such situations, what will be ...

How to Truncate Text After Character in Excel (4 Suitable Ways)

In this article, we will learn how to truncate text after a character in Excel. Sometimes we need to truncate any cell information dependent on ...

How to Apply Abbreviation Using Formula in Excel

While working in Excel, users often need to abbreviate text. The texts can be the name of a person, company, or organization. But there is no single ...

How to Create a Subtraction Formula in Excel (7 Quick Ways)

Microsoft Excel holds a strong position in the software market as a powerful calculation software. Though there is no exact function to subtract two ...

How to Copy PDF File Names into Excel (9 Efficient Methods)

The article will show you how to copy PDF file names into Excel. Sometimes we may require classifying the files in a folder by their Extension and ...

How to Use AutoComplete in Excel (4 Easy Ways)

When we begin entering data into a cell, Excel suggests duplicate values from its related cells, and we can acquire the duplicate values by simply ...

How to Remove Comma Between Numbers in Excel

Commas have several uses while dealing with spreadsheets in Excel. For example, they improve the readability of numbers. However, there may be ...

How to Create Table of Contents for Tabs in Excel (6 Methods)

Sometimes, the Excel workbook becomes large because of numerous worksheets. Because of having several worksheets, it is tough to overview all of ...

How to Create Table of Contents in Excel with Hyperlinks (5 Ways)

Sometimes, the Excel workbook becomes large because of numerous worksheets. Because of having several worksheets, it is tough to overview all of ...

How to Create Table of Contents in Excel with Page Numbers

When you work on multiple worksheets in excel, it is obvious to keep track of each of them. You will need a shortcut to access any worksheet. This is ...

How to Create Table of Contents Without VBA in Excel

While working with Microsoft Excel, you may have dealt with several sheets in your workbook. However, if you need to create a table of contents with ...

How to Move Negative Sign at End to Left of a Number in Excel

Often, users enter a negative sign at the end of a number in Excel. According to Excel usage, a negative sign at the end of any number converts the ...

How to Add Text to Multiple Cells in Excel (10 Easy Methods)

Need to learn how to add text to multiple cells in Excel? If you are looking for such unique tricks, you’ve come to the right place. Here, we will ...

How to Add Text in the Middle of a Cell in Excel (5 Easy Methods)

The article will show you how to add text in the middle of a cell in Excel. If you work in a digital shop, you know that every product has its own ...

How to Count Words in Excel with Formula (2 Handy Examples)

Excel Doesn’t provide any built-in functions that can count words in a cell or a range of cells. However, by combining different functions you can ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo