SUBSTITUTE Function

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 Add a Comma Between City and State in Excel (6 Ways)

We like decorating our things, even in case of a dataset. Adding comma between city and state will help us to differentiate those two quite easily. ...

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 ...

Excel Convert to Number Entire Column (9 Simple Methods)

Whenever working with Excel conversion to numbers is often needed. The main focus of this article is to demonstrate how to convert to number entire ...

Convert Currency to Words in Excel (with Easy Steps)

Excel is an extremely powerful tool to calculate and handle accounting formatted data. When working with accounting, sometimes we need to convert the ...

How to Insert Comma Between Words in Excel (4 Simple Methods)

In this tutorial, I will show you 4 simple methods to insert a comma between words in excel. When you have small datasets, inserting commas inside ...

How to Convert Text with Spaces to Number in Excel (4 Ways)

We often need values in number format to apply them in various formulas and do other stuff too. In that case, if they are in text format, we will ...

How to Convert Number to Words in Excel Without VBA

We often need to convert a number to words in Excel for various purposes. We can use it frequently in shops, educational institutes, banks, etc. A ...

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 Remove Bullets and Numbering in Excel (3 Effective Ways)

The usage of bullet points and numbering are pretty rare in MS Excel. You may find the bullets and numbering in your Excel sheets when you brought ...

How to Convert Special Characters in Excel (6 Easy Ways)

Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. Sometimes, we use special characters ...

How to Add Comma in Excel Between Names (4 Suitable Ways)

If you are searching for the solution or some special tricks to how to add comma in Excel between names then you have landed in the right place. ...

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 ...

Convert Number to Military Time in Excel (2 Easy Methods)

This article will illustrate how to convert number to military time in Excel. Have a look at the following image to get an overview. ...

ExcelDemy
Logo