CONCATENATE Function

How to VLOOKUP from Multiple Columns with Only One Return in Excel (2 Ways)

The VLOOKUP function is a game-changer when you have to retrieve information from a range of data in the same or different worksheets. The Excel ...

How to Use CONCATENATE Function in Excel (4 Examples)

Today I will be showing how you can join two or more texts or numbers into one single text value using the CONCATENATE function of Excel. ...

How to Use IF Function in Excel (8 Suitable Examples)

In Microsoft Excel, the IF function is used to check if a condition is met and then the defined statements will be shown based on the given ...

How to Add a 1 in Front of Numbers in Excel [7 Special Tricks]

You may attach a special type of number like 1 before the local phone number of the US to make it an international identity. It is also mentionable ...

How to Find Unique Values from Multiple Columns in Excel

Today I will be showing how you can extract unique values from multiple columns in Microsoft Excel. Download Practice Workbook How to Find ...

Excel Convert Number to Text with Leading Zeros: 10 Effective Ways

Leading zeros aid predominantly to specify the length of a number. In the case of maintaining records such as any special identity number, zip code, ...

Excel Formula to Copy Cell value to Another Cell

Copying might be a monotonous phase while using Excel. Using formulas can bring some life to this copy task. The agenda for today’s tutorial is to ...

How to Add Leading Zeros in Excel (4 Quick Methods)

While working in Excel, we often have to add leading zeros before one or more numbers. This is in fact quite easy to implement. Today I will be ...

Add or Keep Leading Zeros in Excel (10 Suitable Ways)

In Microsoft Excel, it’s not possible to keep leading zeros by simply typing a number with 0’s at first as Excel, by default, will remove those zeros ...

INDEX MATCH Multiple Criteria in Excel (Without Array Formula)

Two of the widely used functions of Excel are the INDEX function and the MATCH function that can be used to match multiple criteria using both Array ...

How to Merge Multiple Cells in Excel at Once (3 Quick Ways)

While working in Excel, we often have to merge multiple cells in Excel at once for various purposes. Here in this article, I am showing some easy ...

How to Concatenate Multiple Cells in Excel (8 Quick Approaches)

If you’re looking for some easy & handy ways to concatenate or combine multiple cells into a single one, then this article should help you the ...

Switch first and last name in Excel with comma (5 Easy Ways)

In this article, I will show how to switch first and last names in Excel with a comma. Depending on the problems, you might face many ...

Division formula in Excel for multiple cells

Do you want to know how to use the division formula in Excel for multiple cells? You are in the right place. Let’s start… What is the division ...

Excel Dynamic Range Based on Cell Value

In this article, we will be discussing the "Excel Dynamic range Based on Cell Value". Here, we will be creating dynamic ranges without selecting them ...

ExcelDemy
Logo