IF Function

How to Find Text in Cell in Excel

While working in Excel, we often have to search for a specific text within another text. Today I will be showing how to find a text within another ...

How to Find a Character in String in Excel

In Excel, we can find a specific character within a string. Several built-in functions help us finding the character. Today we are going to show you ...

How to Find If A Range of Cells Contains Specific Text in Excel (4 Methods)

While handling a large database you may need to find a specific text from the database. Excel has some functions by which you can easily do that. ...

Excel Search for Text in Range (11 Quick Methods)

In Microsoft Excel, there are numerous methods available to search for text in a range of cells or an array. You can search for a text value and ...

How to Find If Cell Contains Specific Text in Excel

In Excel, circumstances may demand checking whether a cell contains a specific text or not. Today we are going to show you how to check if a cell ...

How to Number Columns in Excel Automatically (5 Easy Ways)

While working in Excel, we often have to number our rows and columns for quick glancing and sophistication in analyzing. Today I will be showing how ...

Combine Text in Excel (8 Suitable Ways)

In Microsoft Excel, numerous methods are available to combine text with different criteria. In this article, you’ll get to learn all of those quick ...

How to Number Rows in Excel (9 Simple Methods)

In Excel, you may come across repetitive tasks often. To number rows is one of these tasks which can be a time-consuming one. There are several ways ...

How to AutoFill Numbers in Excel (12 Ways)

There are several short and quick methods to autofill numbers in Microsoft Excel. In this article, you’ll learn how you can easily apply those useful ...

How to Insert Date in Excel (7 Simple Methods)

There are several purposes for inserting dates in Excel; tracking any information or for any date-time calculation you need to insert dates. Today we ...

How to Change Dates Automatically Using Formula in Excel

For easing your task you may demand automatic update of date, time sequence number, etc. Excel provides you with a feature for that. Today we are ...

Automatic Numbering in Excel (9 Approaches)

Automatic numbering in Excel is a great way to save time and avoid boredom while you are dealing with a large database. Unlike other Excel Office ...

How to Extract Data From Table Based on Multiple Criteria in Excel

Extracting the data on the time of necessity is the prime factor of using any spreadsheet, Excel is not an exception. You store data in tabular form ...

How to AutoFill Cell Based on Another Cell in Excel (5 Methods)

We often need to copy and paste our data in Excel but it can get irritating when you are dealing with a large database. In this situation Excel ...

How to Create Dynamic List in Excel Based on Criteria (Single and Multiple Criteria)

Today I will be showing how to create a dynamic list based on single or multiple criteria in Excel. What is a Dynamic List In Excel? A ...

ExcelDemy
Logo