People may add single quotation marks or apostrophes (‘) to Excel cells for various reasons. One common reason is to treat the value in the cell as text instead of a number or a date. But after adding the single quotation marks (‘), it can be harder to work with the data. Thankfully, there are…
The UPPER function is one of the text functions in Microsoft Excel. You can use it as a standalone function as well as in collaboration with the other functions. This article will give you an overview of the UPPER function in Excel. Objectives The UPPER function converts the input text string into uppercase letters. For…
![How to Remove Duplicates in Excel [14+ Different Methods]](https://excelgraduate.com/wp-content/uploads/2022/06/Remove-Duplicates-in-Excel-3.png)
One of the most obvious tasks as part of the data cleaning process is to remove duplicates. Well, there are different types of cases that require different types of approaches for removing duplicates. Considering all the different scenarios, I’ve come up with all possible solutions to remove duplicates in Excel. I’m going to use a…
When you are working in Excel, sometimes data have dashes or hyphens(-). Very often, you need to remove those dashes to process data. There are several ways by which you can remove dashes or hyphens(-) from an Excel worksheet. Here, I’m going to show you more than 3 easy methods to remove dashes in Excel….
Many people find it difficult to insert and run VBA code in Excel. This article is a general guide for inserting and running any type of VBA 2 Ways to Insert VBA Code in Excel There are two ways available to insert a VBA code in Excel. First, you can create a new Module and…
![Find Matching Values in Two Worksheets in Excel [5 Methods]](https://excelgraduate.com/wp-content/uploads/2022/04/Find-Matching-Values-in-Two-Worksheets-in-Excel-10.png)
To find matching values in two worksheets in Excel, follow the steps below: This formula will compare the range D2:D10 of sheet “List 1” with that of sheet “List 2”. It returns TRUE for duplicate value and FALSE for unique value. Throughout this article, I will be using two sheets (List 1 and List 2)…
We often need to find similar texts in two columns in Excel. Well, there are quite a few handy techniques to do that. I am going to discuss 5 different methods to identify similar texts or characters in two columns in Excel. Find Similar Text in Two Columns in Excel Using IFERROR Function To find…
There are great tools and commands to find duplicates in two or more columns in Excel that will ease your work and save a lot of time to treat lengthy datasheets. In this article, I will show you 7 easy methods to find duplicates in two columns in Excel. Find Duplicates in Two Columns with…
