# How to compare two cells

Views: 2
The tutorial shows how to compare text strings in Excel for case-insensitive and exact match. You will learn a number of formulas to compare two cells by their values, string length, or the number of occurrences of a specific character, as well as how to compare multiple cells.

## Compare Text

In this article, we will illuminate you about how we can compare strings of two cells in Microsoft Excel. We will use EXACT function to compare the text and other way we can compare by matching the strings with each other. Let’s take an example to understand how we can match the strings in Excel: We have 2 columns, in which we have formula list. We need to compare both the columns, if text color matches or not.

## The EXACT Formula

Let’s look today at a really quick nice way to compare two text cells of cells containing strings in Excel using the EXACT Formula. You will need two arguments to be matched against each other. The syntax of the formula is =EXACT(text1,text2)...

## How to Find and Remove Merged Cells

Do you merge cells in Excel? If yes, you need to know a few drawbacks of merging cells. To begin with, if you try and sort cells that have been merged, it will refuse to do so and show you an error that says – To do this, all the merged cells need to be of the same size...

## Excel 2010 Cell Basics

You will need to know the basic ways you can work with cells and cell content in Excel to be able to use it to calculate, analyze, and organize data. In this lesson, you will learn how to select cells; insert content; and delete cells and cell content. You will also learn how to cut, copy and paste cells; drag and drop cells; and fill cells using the fill handle.

## How to Center Text Across Multiple Cells

If you have a label or heading on a spreadsheet in Excel that you want to center across a certain number of cells, there are couple of ways you can do this, with or without merging cells. We’ll show you both ways. First, we’ll center text across cells by merging cells. To do this, select the cells you want to merge.

## Selecting Only Constants or Formulas

Sometimes you want to do something — such as format, delete or edit — all cells containing constants or formulas at the same time. Here’s how to select all such cells so you can thereafter do to them what you want. Microsoft created the moniker “Special Cells” as an umbrella name for groups of different classifications of cells. There is nothing special about Special Cells except their condition of interest at the moment you care about them.

## Conditionally Formatting Locked and Unlocked Cells

There are times when your users will find it easier to enter data directly into worksheet cells, instead of a userform interface. You’ll want to protect all the cells containing formulas and static header labels, while allowing certain cells to be unprotected for users to input data.

## Delete Values From Cells While Keeping Formulas

One common way to set up a spreadsheet is to have input cells (which the user changes) and formula cells which work in tandem with those user input cells to display the results of the formulas. But what if you want to delete all of the data thats in the input cells but keep your formulas intact.

## Excel 2010 Modifying Columns, Rows, and Cells

When you open a new, blank workbook, the cells are set to a default size.You do have the ability to modify cells, and to insert and delete columns, rows, and cells, as needed. In this lesson, you will learn how to change row height and column width; insert and delete rows and columns; wrap text in a cell; and merge cells.

## How to find merged cells

Merged cells, they cause havoc with a spreadsheet. The Effects can be far reaching and sometimes not appear at the time of development. If you do use merged cells you will run the risk of the following issues: Losing the ability to sort your data correctly. Inability to run VBA if necessary- it does not handle merged cells very well...