SUBSTITUTE Function Archives

How to Find Distance Between Zip Codes in Excel Using Formula

Dec 27, 2022 Excel Formulas

In this tutorial, I am going to show you 2 easy methods of how to find the distance between zip codes in Excel using a formula. You can quickly use ...

How to Count Alphabet in Excel Sheet (5 Easy Methods)

Jan 3, 2023 Excel Formulas 2

Whenever you work with a dataset that contains some sentences or words, you may need to count the alphabet in the Excel sheet. Excel shines here, ...

How to Find Great Circle Distance Using Excel Formula

Jan 4, 2023 Excel Formulas

This tutorial will demonstrate how to find Great Circle Distance using the Excel formula. When we are dealing with the surface of a sphere, we need ...

How to Count Specific Words in Excel (3 Effective Ways)

Jan 3, 2023 Excel Formulas

Microsoft Excel is a powerful software that uses Excel functions to count almost anything. Unfortunately, Excel doesn't come with a built-in feature ...

How to Count Words in Excel (6 Easy Methods)

Jan 3, 2023 Excel Formulas

In this article, I will show you how to count words in Excel. While working in Excel, we may want to calculate the total number of words in a cell or ...

How to Truncate Spaces in Excel (5 Easy Methods)

Jan 2, 2023 Excel Formulas

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 Calculate Permutations Without Repetition in Excel

Jan 2, 2023 Excel Formulas

Permutation is such a great mathematical concept that has a significant impact on every aspect of education. We can see its usage in math, quantum ...

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

Jan 2, 2023 Excel Formulas

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

Jan 1, 2023 Excel Basics

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 Remove Prefix 91 in Excel (4 Easy Ways)

Nov 27, 2022 Excel Formulas

There are instances when we need to remove the country code while working with a collection of phone numbers in Excel. We may exclude those country ...

How to Find ZIP Code from Address in Excel (2 Easy Ways)

Dec 29, 2022 Excel Formulas

Finding ZIP Code or Postal Code can be a troublesome job to do in Excel if you don’t know the correct procedure. But it’s rather quite an easy thing ...

How to Convert Hex to Decimal in Excel (2 Practical Examples)

Feb 7, 2023 Excel Formulas

When working with numbering systems, Hexadecimal and Decimal both systems are significant from their own perspectives. So, it is a frequent need for ...

How to Remove Last 4 Digits of Zip Code in Excel (10 Easy Ways)

Dec 28, 2022 Excel Formulas

Zip codes are essential for delivering parcels through postal services to reach a correct destination. Zip codes contain 9 digits, among which the ...

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

Dec 28, 2022 Excel Basics

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 Convert European Number Format to US in Excel (4 Ways)

Feb 7, 2023 Excel Formulas

A Number format is a standard to present a number that is understandable to mass people. In different regions of the world, different types of number ...