Latest Posts

How to Create List from Range in Excel (3 Methods)

While working with a large database, you may need to create a list of data or text from the given database. If you do it manually, it will cost you a ...

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 And Replace Values Using Wildcards in Excel

While dealing with data in Excel you may need to eradicate errors or modify your data regularly. Removing errors or regular modification, on both ...

Find External Links in Excel (6 Quick Methods)

While working with Microsoft Excel, it’s a common scenario to look for external links and references in the active workbook. In this article, you’ll ...

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 Copy the Same Value in Multiple Cells in Excel (4 Methods)

Copying cell values in multiple cells and pasting them is one of the easiest jobs in Microsoft Excel. You can copy single or multiple cells and then ...

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 ...

VLOOKUP to Return Multiple Columns in Excel (4 Examples)

In Microsoft Excel, there are several formulas available to VLOOKUP and return values from multiple columns. As the VLOOKUP function is not able to ...

How to Concatenate String and Integer using VBA

In our daily use of Excel, we face situations where concatenating strings and integers becomes a necessity. In these articles, we showed ways of ...

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 Combine Date and Time in One Cell in Excel (4 Methods)

While making a time log of activities in Excel, you may want to enter both the date and time in a single cell. In most cases, you may have dates in ...

Concatenate Numbers in Excel (4 Quick Formulas)

In Microsoft Excel, there are numerous ways available to concatenate or join numbers to display in a single cell. The numbers can be of different ...

How to Combine Rows into One Cell in Excel

Today I will be showing how to combine rows into one cell in Excel. While working in Excel, trying to combine rows or columns is one of the most ...

ExcelDemy
Logo