SUBSTITUTE Function Archives - Page 2 of 17

SUBSTITUTE Function

How to Count Words Separated by Comma in Excel Cell

Mar 6, 2023 Excel Formulas

Excel has lots of functions to perform different tasks. But sometimes one single function is not capable of solving a problem. That time we need to ...

Excel Text to Columns Not Working (4 Reasons with Solutions)

Feb 8, 2023 Excel Formulas

Excel's Text to Columns function is quite helpful. Data that is contained in a single column may often be divided into many columns using this ...

How to Remove Inverted Comma in Excel (7 Easy Methods)

Dec 4, 2022 Excel Formulas

When we import data in Excel, we may often encounter some Inverted Comma in data that creates problems while calculating data because it may change ...

How to Find and Replace Multiple Words from a List in Excel

Mar 19, 2023 Excel Basics

Looking for ways to find and replace multiple words in a word from an Excel list? Then, this is the right place for you. Here, you will find 8 ...

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

Feb 9, 2023 Excel Basics

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 Convert Alphabet to Number in Excel (4 Easy Ways)

Dec 26, 2022 Excel Formulas

In this article, we will learn to convert the alphabet to number in Excel. In Excel, we can use different functions to change an alphabet to a ...

How to Split Text to Columns Automatically with Formula in Excel

Jan 11, 2023 Advanced Excel

Sometimes we face the necessity of organising text in specific columns. We can use Text to Columns feature, apply different formula or VBA code. In ...

How to Convert Text to Columns Without Overwriting in Excel

Feb 20, 2023 Advanced Excel

Frequently, we need to convert text to columns in Excel in our day-to-day tasks. In fact, Microsoft Excel is an excellent tool to perform this task. ...

How to Convert Text to Columns with Multiple Delimiters in Excel

Feb 26, 2023 Advanced Excel

Converting text to columns is a common task in our day-to-day lives indeed. In countless situations, we have to split texts into columns, and this is ...

How to Change International Number Format in Excel (4 Examples)

Feb 9, 2023 Excel Basics

Often, we need to use large numbers in international number format in our excel sheet. It becomes difficult to read those numbers if the formatting ...

How to Add Comma Before Text in Excel (6 Suitable Ways)

Dec 20, 2022 Excel Formulas

Whenever working with Excel you may face a situation where you will need to add comma before text. The main objective of this article is to explain ...

How to Change Date Alignment in Excel (8 Simple Methods)

Dec 20, 2022 Excel Basics

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using excel tools and features. There are many default ...

How to Use AutoComplete in Excel (4 Easy Ways)

Feb 7, 2023 Excel Basics

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 Change Semicolon to Comma in Excel (6 Effective Ways)

Dec 20, 2022 Excel Formulas

Preparing Excel worksheet and have given semicolon mistakenly instead of a comma in your texts? Want to change semicolon to comma but find it ...

How to Remove Comma in Excel Using Formula (2 Ways)

Feb 8, 2023 Excel Formulas

Commas have a variety of applications while working with Excel spreadsheets. They are quite useful too. But there are certain situations when you ...