SUBSTITUTE Function Archives

How to Truncate Spaces in Excel (5 Easy Methods)

Jan 2, 2023

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 Spaces in Excel (5 Easy Methods)

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

Jan 2, 2023

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 Truncate Text After Character in Excel (4 Suitable Ways)

How to Apply Abbreviation Using Formula in Excel

May 31, 2023

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 Apply Abbreviation Using Formula in Excel

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

Sep 20, 2023

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 Create a Subtraction Formula in Excel (7 Quick Ways)

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

Feb 9, 2023

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 Copy PDF File Names into Excel (9 Efficient Methods)

How to Use AutoComplete in Excel (4 Easy Ways)

Feb 7, 2023

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 Use AutoComplete in Excel (4 Easy Ways)

How to Remove Comma Between Numbers in Excel

Sep 24, 2023

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

How to Remove Comma Between Numbers in Excel

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

Sep 21, 2023

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 for Tabs in Excel (6 Methods)

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

Feb 9, 2023

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)

How to Create Table of Contents in Excel with Page Numbers

Dec 7, 2022

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 in Excel with Page Numbers

How to Create Table of Contents Without VBA in Excel

Dec 7, 2022

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 Create Table of Contents Without VBA in Excel

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

Dec 7, 2022

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 Move Negative Sign at End to Left of a Number in Excel

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

Feb 16, 2023

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 to Multiple Cells in Excel (10 Easy Methods)

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

Feb 7, 2023

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 Add Text in the Middle of a Cell in Excel (5 Easy Methods)

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

Jul 7, 2022

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