Posted inFunctions
How to use the FIND function to combine text and date in Excel
In this article, you will learn how to use the FIND function in Excel to…
Posted inFunctions
How to Use the REPLACE Function to Replace and Calculate in Excel Formula
The REPLACE function in Excel is a text function that allows you to replace a…
Posted inFunctions
How to Use the SUBSTITUTE Function in Excel to Combine and Separate Columns
The SUBSTITUTE function in Excel is a text function that can replace text in a…
Posted inFunctions
How to use the SUBSTITUTE function to remove word wrapping in cells in Excel
Sometimes, when you copy and paste text from another source into Excel, you may encounter…
Posted inFunctions
How to Use the SUBSTITUTE Function in Excel to Convert Numbers to Words
Sometimes, you may need to convert numbers to words in Excel, such as writing a…
Posted inFunctions
How to use the SUBSTITUTE function in Excel
The SUBSTITUTE function in Excel is used to replace one or more instances of a…
Posted inFunctions
How to Use the SUBSTITUTE Function in Excel
The SUBSTITUTE function in Excel is used to replace one or more instances of a…
Posted inFunctions
How to Use the EXACT Function to Compare Two Columns in Excel
The EXACT function in Excel is a text function that compares two text strings and…
Posted inFunctions
How to Use the MID Function to Sum the Digits of a Number in Excel
The MID function in Excel is used to extract a substring from a text string,…
Posted inFunctions
How to Use the MID Function to Separate Last Name from First Name in Excel
Sometimes, you may have a column of data that contains both the first name and…
