CONCAT Function Archives

Types of Data Entry in Excel (A Quick Overview)

Jun 13, 2022 Advanced Excel

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)

Jun 14, 2022 Excel Basics

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)

May 23, 2022 Excel Basics

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)

Jun 5, 2022 Excel Formulas

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)

May 30, 2022 Excel Formulas 1

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)

May 26, 2022 Excel Formulas

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)

Apr 25, 2022 Excel Basics

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)

May 26, 2022 Excel Formulas

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)

May 26, 2022 Excel Formulas

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)

May 26, 2022 Excel Formulas

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)

May 26, 2022 Excel Formulas

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)

May 26, 2022 Excel Formulas

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)

Mar 10, 2022 Excel Basics

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)

May 24, 2022 Excel Formulas

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)

May 25, 2022 Excel Formulas

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