SUBSTITUTE Function Archives - Page 3 of 17

SUBSTITUTE Function

How to Use CHAR(10) Function in Excel (3 Practical Examples)

Dec 20, 2022 Excel Formulas

While working in Excel, sometimes you need to break your line or connect two strings to make your report or presentation more lucrative and ...

Character Codes for CHAR Function in Excel (5 Common Uses)

Jan 15, 2023 Excel Formulas

Looking for a way to use Excel character codes for the CHAR function? Don’t worry, you have come to the right place. In this article, I will show you ...

How to Use CHAR(32) Formula in Excel (5 Practical Examples)

Dec 20, 2022 Excel Formulas

The article will show you an application of using the CHAR function in Excel. Suppose you have a range of IDs in the dataset and you want a space in ...

How to Remove Comma Between Numbers in Excel

Dec 18, 2022 Excel Formulas

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

How to Use Cell Address in Excel Formula (4 Useful Methods)

Dec 19, 2022 Excel Formulas

Sometimes, while working on an Excel worksheet, one may need to Use Cell Address in Excel Formula. Addressing a cell becomes essential when you need ...

How to Get Cell Value by Address in Excel (6 Simple Methods)

Feb 27, 2023 Excel Formulas

In this tutorial, I am going to show you 6 simple methods of how to get cell value by address in excel. You can quickly use these methods even in ...

How to Remove Comma from Currency in Excel (6 Handy Tricks)

Dec 18, 2022 Excel Formulas

Does comma in numbers in an Excel worksheet bother you? Do you want to clean up your data by removing the comma from the number describing currency? ...

How to Convert UTC to EST in Excel (3 Easy Ways)

Dec 18, 2022 Excel Formulas

In this article, we will learn to convert UTC to EST in Excel. UTC stands for Coordinated Universal Time. It was previously known as Greenwich Mean ...

How to Convert Hours to Days in Excel (6 Effective Methods)

Dec 13, 2022 Excel Formulas

Working on time schedules for different purposes has become easier with excel. It helps to convert hours to days and vice versa in many different ...

How to Convert Minutes to Hundredths in Excel (3 Easy Ways)

Dec 14, 2022 Excel Formulas

Companies may use tenths or hundredths of minutes to calculate wages. As a result, it may be required to convert minutes to hundredths in Excel. ...

How to Cut Text Using Formula in Excel (6 Simple Methods)

Jan 10, 2023 Excel Basics

Sometimes we create a dataset with all the pieces of information in a single cell. But while making the final report we need to cut some text from ...

How to Calculate Travel Time Between Two Cities in Excel

Dec 12, 2022 Excel Formulas

Microsoft Excel may determine the separation between two specific cities or locations on the planet. It is essential to be able to determine the ...

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

Dec 11, 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 Find Carriage Return in Excel (2 Easy Methods)

Dec 11, 2022 Excel Formulas

Carriage return is a very important element in excel cells. It defines the cell length along with the information within it. In some cases, we need ...

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

Feb 8, 2023 Excel Basics

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