Latest Posts

How to Convert General Format to Date in Excel (7 Methods)

Working with Microsoft Excel's Date format is very common. We use them for various calculations. The Date is one of the essential formats in Excel. ...

How to Extract Data from Excel Based on Criteria (5 Ways)

Sometimes we may need to search for certain data to work with. But when the dataset is huge, it is really hard to find what we are looking for. In ...

How to Split One Column into Multiple Columns in Excel : 7 Easy Ways

Sometimes it becomes difficult to find value from a long column in Excel. So we need to split one column into multiple columns. It makes the dataset ...

How to Remove Blank Lines in Excel (8 Easy Ways)

If your Excel dataset contains unnecessary blank lines or empty rows, you may need to remove those. In this article, I will introduce you to 8 easy ...

How to Find Duplicate Rows in Excel (5 Quick Ways)

While working in Excel there may be some duplicate records in your data range of a worksheet, and now you want to find or highlight the duplicate ...

How to Separate Two Words in Excel (6 Easy Ways)

Separating two words in Excel is quite handy in order to extract data from a dataset. In this article, we use LEFT, RIGHT, LEN, SEARCH, FIND ...

Insert Rows in Excel Based on Cell Value with VBA (2 Methods)

In this article, I’ll show you how you can insert rows in Excel based on cell value with VBA. You’ll learn to insert rows after each row, as well as ...

Excel Paste Transpose Shortcut: 4 Easy Ways to Use

In this article, we will discuss the Transpose option of Excel Paste Shortcut. In Excel, we generally transpose Rows to Columns or vice-versa. We can ...

How to Convert Text to Date in Excel (10 ways)

If you are looking for some of the easiest ways to convert text to date in Excel, then you will find this article useful. So, let’s dive into the ...

How to Split a Cell into Two Rows in Excel (3 ways)

If in a large dataset multiple information are compacted in one cell, then it is hard to find and lookup data to view or to do any task. In this ...

Invoice Excel Formula

Many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make databases for ...

How to Convert Date to Text Month in Excel (8 Quick Ways)

When we enter a date in Excel then it is possible to extract the month name from the date. This article will guide you with 8 quick useful methods to ...

Delete an Excel Row If a Cell Contains Specific Values (3 Methods)

While working with data in Excel, the deletion of an Excel row is quite a common phenomenon. There are a good number of methods that we can use to ...

How to Convert Text to Number in Excel with VBA (3 ways)

In Microsoft Excel, working with numbers is most common. Sometimes, we have to process a dataset with large amounts of numbers. But, you may find ...

Convert Number (YYYYMMDD) to Date Format in Excel

You might have the date in your dataset in a format like YYYYMMDD (e.g., today’s date is 20211128) or, as the count of total days since January 1, ...

ExcelDemy
Logo