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…
Posted inFunctions
How to use the SEARCH function to separate first name from last name in Excel
In this article, we will learn how to use the SEARCH function in Excel to…
Posted inFunctions
How to use the LEFT function to convert invalid numbers to valid numbers in Excel
The LEFT function in Excel returns a specified number of characters from the left side…
Posted inFunctions
How to Use the LEFT and RIGHT Functions to Separate a Text String of Numbers in Excel
Sometimes, you may have a text string of numbers that you want to separate into…
Posted inFunctions
How to Use the IFERROR Function in Excel
The IFERROR function in Excel is a useful way to handle errors that may occur…
Posted inFunctions
How to Use the IF Function to Create Your Own Timesheet in Excel
The IF function is one of the most useful and versatile functions in Excel. It…
Posted inFunctions
How to Use the IF Function to Check Whether a Date is in the Past or the Future in Excel
The IF function is one of the most commonly used functions in Excel. It allows…
Posted inFunctions
How to Use the SWITCH Function in Excel
The SWITCH function in Excel is a logical function that evaluates an expression and returns…