CONCAT Function

Types of Data Entry in Excel (A Quick Overview)

Microsoft Excel is one of the leading data organizing and analyzing programs. But to analyze data in Excel, you need to input data first. Data can be ...

How to Put 0 in Excel in Front of Numbers (5 Handy Methods)

While working on an Excel worksheet, you may see that Excel doesn’t allow 0 before any numbers. So, you can’t make a column with the same number of ...

Hide Duplicate Rows Based on One Column in Excel (4 Methods)

Hiding duplicate rows are one of the most frequent tasks that we need to do in Excel. In this article, you will learn 4 methods to hide duplicate ...

How to Do a Line Break in Excel (4 Ways)

Line breaks are important to improve visuals in cells. It can also be used to store more than one piece of data if needed in a single cell. Whatever ...

How to Merge Rows with Comma in Excel (4 Quick Methods)

In this article, we will learn to merge rows with the comma in Excel. Unfortunately, there is no method to merge rows directly with each other. Here, ...

How to Merge Multiple Cells without Losing Data in Excel (6 Methods)

In this article, I will discuss how you can merge multiple excel cells without losing data. While working in Microsoft Excel, you may want to join ...

How to Write Phone Number in Excel (Every Possible Way)

Usually, Excel treats phone numbers as just another number entered in a cell unless we modify it or write it manually otherwise. Entering each phone ...

How to Convert Date to Month and Year in Excel (4 Ways)

In this article, we will learn how to Convert Date to Month & Year in Excel. Sometimes we need to eradicate the day count from the Date & use ...

How to Combine Name and Date in Excel (7 Methods)

This article will show you 7 different easy ways on how to combine name and date in Excel. Sometimes we need to provide people’s names with their ...

How to Combine Names in Excel with Space (6 Approaches)

In order to get the Full Name at a time from separate columns, we need to combine those cells. Here, we are going to learn some easy and smooth ...

How to Combine Two Cells in Excel (6 Quick Methods)

In this article, we will learn How to Combine Two Cells In Excel. In Excel when data are Split across different cells, one can easily Combine them ...

How to Combine Two Cells in Excel with a Dash (5 Methods)

In this article, we have shown 5 methods of how to combine two cells in Excel with a dash. Let's consider a scenario where a car dealer gives its ...

How to Write 001 in Excel (11 Effective Methods)

Excel automatically removes the leading zeros from a number when you enter it in a  cell. Therefore, you cannot directly write 001 in excel and ...

How to Concatenate Rows in Excel (11 Methods)

In this tutorial, I will discuss how to concatenate cell contents that spread over several rows in excel. Basically, concatenate means ...

Concatenate Multiple Cells Based on Criteria in Excel (4 Methods)

Sometimes it becomes necessary in excel to concatenate multiple cells based on criteria. This article shows how to do that in 4 different ways. The ...

ExcelDemy
Logo