SUBSTITUTE Function Archives - Page 16 of 17

How to Apply Subtraction Formula in Excel (8 Easy Ways)

Feb 8, 2023

We all know basic subtraction. It is mainly about finding differences between two or more values. This article will show you how to apply subtraction ...

How to Apply Subtraction Formula in Excel (8 Easy Ways)

Find And Replace Multiple Values in Excel (6 Quick Methods)

Dec 20, 2022

In Microsoft Excel, it’s a usual scenario to find and replace multiple text or numeric values. You can use the Find and Replace command, apply ...

Find And Replace Multiple Values in Excel (6 Quick Methods)

Opposite of Concatenate in Excel (4 Options)

Mar 14, 2023 3

In Microsoft Excel, there is no exact function that works as the opposite of concatenate function. But still, we have a number of suitable procedures ...

Opposite of Concatenate in Excel (4 Options)

How to Sort by Last Name in Excel (5 Useful Methods)

Feb 7, 2023

If you work with datasets in Excel, you will often need to sort these datasets by name. Sometimes. You may need to sort the dataset based on your ...

How to Sort by Last Name in Excel (5 Useful Methods)

How to Use TRIM Function in Excel (7 Suitable Examples)

May 30, 2023

Excel provides several text functions to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use a text ...

How to Use TRIM Function in Excel (7 Suitable Examples)

How to Use the SUBSTITUTE Function in Excel (7 Examples)

May 23, 2023

The SUBSTITUTE function is one of the text functions available in Excel that replaces the existing text with new text in a string. If you want to ...

How to Use the SUBSTITUTE Function in Excel (7 Examples)

How to Use RIGHT Function in Excel (6 Suitable Examples)

May 30, 2023 2

RIGHT is another popular function in MS Excel that is used to get the last character or characters in a text string, based on the specific number of ...

How to Use RIGHT Function in Excel (6 Suitable Examples)

How to Use REPT Function in Excel (8 Suitable Examples)

May 23, 2023

In Microsoft Excel, the REPT function is generally used to repeat a text or a character a defined number of times in a cell. In this article, you’ll ...

How to Use REPT Function in Excel (8 Suitable Examples)

How to Use REPLACE Function in Excel (3 Suitable Examples)

May 24, 2023

In Microsoft Excel, the REPLACE function is generally used to replace or substitute a text. The replacement is based on its starting position and ...

How to Use REPLACE Function in Excel (3 Suitable Examples)

How to Use LEN Function in Excel (7 Suitable Examples)

May 24, 2023

Microsoft Excel provides a function called LEN for counting letters, numbers, characters, and all spaces. LEN is a short form of LENGTH. The LEN ...

How to Use LEN Function in Excel (7 Suitable Examples)

Fix Excel Date Not Formatting Correctly (8 Quick Solutions)

May 24, 2023 2

In data entry, it’s a common phenomenon that the dates get manipulated with text or other formats. In this article, you’ll learn how you can change, ...

Fix Excel Date Not Formatting Correctly (8 Quick Solutions)

How to Compare Text Between Two Cells in Excel (10 Methods)

May 22, 2023

When we compare just two cells manually, it is not difficult. But it's never easy to compare hundreds and thousands of text strings. Fortunately, MS ...

How to Compare Text Between Two Cells in Excel (10 Methods)

How to Split One Cell into Two in Excel (5 Useful Methods)

Mar 14, 2023

When you import data from a database or any other source, you have to split cell one into two or more in such situations. In this tutorial, I’m going ...

How to Split One Cell into Two in Excel (5 Useful Methods)

How to Separate Numbers Using Formula in Excel (5 Ways)

May 24, 2023 2

Microsoft Excel is a ubiquitous tool for organizing and analyzing data. Oftentimes, we may need to separate numbers in Excel, therefore, knowing a ...

How to Separate Numbers Using Formula in Excel (5 Ways)

How to Extract Only Numbers from Excel Cell (7 Easy Ways)

May 3, 2023 4

Although Microsoft has not provided a straight formula or syntax to extract only numbers from the Excel cell, we can incorporate a wide range of ...