Excel Formulas

How to Concatenate Apostrophe in Excel (6 Easy Ways)

While working in Excel we have to differentiate between entries using various delimiters, then concatenating the delimiter would be a handful there. ...

How to Sum Values by Day in Excel (8 Easy Ways)

You can make summations in Excel based on a specific date or day. In this article, we’ll show you 8 easy ways to sum values by day in Excel. ...

How to Convert Column Number to Letter in Excel (3 Ways)

In this article, we will show you how to convert the column number to letter in Excel in 3 easy and effective ways. How to Convert Column ...

How to Compare Text and Highlight Differences in Excel (8 Quick Ways)

To demonstrate our Methods, we'll use the following dataset containing the names of the best-selling books in an online shop over two consecutive ...

How to Find a Character in Excel String (8 Easy Ways)

If we want to find specific characters of an Employee’s Name and ID, we have to find characters appearing in the Character Sign column. For a better ...

How to Remove Decimals in Excel (13 Methods)

    In the sample dataset, there are a variety of different currencies, quantities and their exchange rate to USD. The decimals need ...

Check If Cell Contains Partial Text in Excel (5 Ways)

We will be using a sample product price list as a dataset to demonstrate all the methods. Method 1 - Check If Cell Contains Partial Text ...

How to Remove Semicolon in Excel?

Sometimes we need to remove semicolon from the worksheet in Excel. Excel has some quick features as well as functions to do so. In this article, we ...

How to Count Numbers in a Cell in Excel?

In this article, we will demonstrate 5 easy ways to do the task effortlessly. For various purposes, like data analysis, data validation, data ...

Excel Find Last Column With Data (4 Quick Ways)

In a large worksheet, finding the last column with data manually is time-consuming and not friendly. There are some functions by using which you can ...

How to Remove Numeric Characters from Cells in Excel?

Today, in this article, we will demonstrate 5 suitable methods of how to remove numeric characters from cells in Excel. However, it is a very common ...

Comparing Two Columns and Returning Common Values in Excel

Microsoft Excel offers several options for comparing columns in MS Excel, but most of them are for searching in one column. This article will help ...

How to Highlight Selected Cells in Excel (5 Easy Ways)

Method 1 - Using Define Name to Highlight Selected Cells in Excel Step 1: Go to Formulas Tab > Select Define Name (in Define Names section). ...

How to Remove Blank Spaces in Excel -7 Methods

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

How to Count Occurrences of a Character in String in Excel

Counting character occurrences in Excel is vital for data validation, error correction, and text analysis. It ensures data accuracy, supports ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo