SUBSTITUTE Function Archives

SUBSTITUTE Function

How to Replace Carriage Return with Comma in Excel (3 Ways)

Sep 20, 2022 Excel Formulas

If you have a lot of carriage returns in your dataset and finding ways to replace them all with commas then you have come to the right place. Here, ...

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

Sep 26, 2022 Excel Basics

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)

Sep 26, 2022 Excel Basics

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

Find and Replace Tab Character in Excel (2 Suitable Ways)

Sep 20, 2022 Excel Basics

Tab character plays a vital role in Excel usage. With this character, we can quickly create four spaces in one hit. But, during data analysis and ...

Excel Convert to Number Entire Column (9 Simple Methods)

Aug 28, 2022 Excel Basics

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)

Aug 1, 2022 Excel Basics

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

Jul 24, 2022 Excel Basics

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 Add Comma in Excel Between Names (4 Suitable Ways)

Jul 31, 2022 Excel Formulas

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

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

Jul 19, 2022 Excel Formulas

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

How to Convert 4 Digit Number to Time in Excel (3 Methods)

Jul 19, 2022 Excel Formulas

If you are searching for the solution or some special tricks to convert a 4 digit number to time in Excel then you have landed in the right place. ...

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

Jul 7, 2022 Excel Formulas

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

Excel Formula to Count Specific Words in a Cell (3 Examples)

Jul 7, 2022 Excel Formulas

A word can be present in a cell multiple times. There are multiple options to find and count that specific word from a cell in Excel including the ...

How to Calculate Ratio in Excel (4 Handy Methods)

Jun 15, 2022 Excel Formulas 1

The ratio is one of the common ways to compare two values. It indicates the amount of difference between two values from each other. In Excel, we can ...

How to Remove Sign in Excel (With 3 Examples)

Jun 20, 2022 Excel Basics

We work in Excel for different purposes. Like, we work with currency-related operations, and there appear currency signs. And you could imagine a lot ...

How to Calculate Ratio Between Two Numbers in Excel (5 Ways)

Jun 15, 2022 Excel Formulas

In Mathematics, the ratio is used to compare two values . And it helps to compare the relation between two numbers. Excel plays a very easy and handy ...