Excel Formulas Archives - Page 117 of 149

How to Remove Blank Spaces in Excel -7 Methods

Aug 4, 2024

This sample dataset contains cells with multiple blank spaces. Method 1 - Using the TRIM Function to Remove Blank Spaces Enter the ...

How to Remove Blank Spaces in Excel -7 Methods

How to Remove Characters After a Specific Character in Excel

Nov 11, 2025

We may want to trim some characters after a particular character to make our dataset neat and clean in Excel. There are many reasons to remove ...

How to Remove Characters After a Specific Character in Excel

How to Count the Occurrences of a Character in a String in Excel – 4 Examples

Aug 9, 2024

The image below showcases the number of occurrences of characters in a string in some book names. Example 1 - Count the ...

How to Count the Occurrences of a Character in a String in Excel – 4 Examples

How to Split Cells in Excel (6 Easy Tricks)

Jul 3, 2024

Method 1 - Split Cells in Excel with the Text to Column Feature In the following table, we have some random names lying in the Text column. We'll ...

How to Split Cells in Excel (6 Easy Tricks)

If Value Exists in Column Then TRUE in Excel

Jul 2, 2024

Here's an example of how you can implement a function to check if a value from one column exists in another. Download the Practice ...

If Value Exists in Column Then TRUE in Excel

How to Vlookup and Pull the Last Match in Excel – 4 Methods

Aug 3, 2024

This is a sample dataset with a list of products and their quantity. Method 1- Applying the LOOKUP Function to Pull the Last ...

How to Vlookup and Pull the Last Match in Excel – 4 Methods

How to Remove Apostrophe in Excel?

Jul 31, 2024

Unwanted apostrophes can creep into Excel worksheets when copying data from Word or a website, or even from a simple typo. These apostrophes are ...

How to Count Text in Excel (7 Easy Tricks)

Jul 31, 2024

In this article, we will explain how to count text in Excel in 7 different ways. Here's an overview of the dataset we'll use to demonstrate our ...

How to Count Text in Excel (7 Easy Tricks)

Applying Conditional Formatting for Multiple Conditions in Excel

Jun 25, 2024

Here's an overview of using Conditional Formatting for multiple conditions. We have the two data tables, which we'll format. The first table ...

Applying Conditional Formatting for Multiple Conditions in Excel

Find Last Value in Column Greater than Zero in Excel

Nov 11, 2025

We may need to find the last entry, last purchase, or last order greater than zero while using MS Excel for different purposes. There are many ways ...

Find Last Value in Column Greater than Zero in Excel

How to Apply Conditional Formatting with INDEX-MATCH in Excel: 4 Methods

May 29, 2024

Method 1 - Using Conditional Formatting with INDEX-MATCH with a Fixed Lookup Value in Excel (Over a Single Column) Steps: Select the column on ...

How to Apply Conditional Formatting with INDEX-MATCH in Excel: 4 Methods

How to Apply Conditional Formatting to Multiple Columns in Excel – 10 Easy Methods

Aug 3, 2024

The sample dataset (B4:F9) contains names of employees, their projects and their working hours on different days. Method 1 - Use the ...

How to Apply Conditional Formatting to Multiple Columns in Excel – 10 Easy Methods

Highlighting Row with Conditional Formatting Based on Date in Excel

Jun 16, 2024

Here's the overview of the functions we'll use today and how they highlight cells or rows based on dates or ranges. We have a data table with ...

Highlighting Row with Conditional Formatting Based on Date in Excel

How to Find Links in Excel ( 8 Suitable Approaches)

Nov 11, 2025

In this article, we will discuss 8 suitable approaches to find links in Excel. Excel has tremendous available options to link your working workbook ...

How to Find Links in Excel ( 8 Suitable Approaches)

How to Highlight Cells Based on Text in Excel (2 Methods)

Jul 6, 2024

Highlighting cells with specific text in MS Excel is useful for easily finding matching text in datasets. Our sample dataset contains a list of ...