Concatenate Excel Archives

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

How to Concatenate Multiple Cells with Comma in Excel (4 Ways)

May 25, 2022 Excel Formulas

To get a comprehensive idea of anything at once, you may need to concatenate multiple cells and separate them by using commas. This article is ...

Excel INDEX MATCH to Concatenate Multiple Results (With 2 Easy Steps)

May 24, 2022 Excel Formulas

While working in Microsoft Excel we might need to concatenate different multiple results from a particular dataset. In this article, we will ...

How to Bold Text in Concatenate Formula in Excel (2 Methods)

Jun 19, 2022 Excel Formulas

With Excel CONCATENATE function you can join two or more texts altogether. But unfortunately, there is no way to bold text in Concatenate formula ...

Concatenate Multiple Cells but Ignore Blanks in Excel (5 Ways)

May 25, 2022 Excel Formulas

In Microsoft Excel, you will encounter various situations where you will have to concatenate multiple cells. It is one of the crucial Excel tasks. ...

Carriage Return in Excel Formula to Concatenate (6 Examples)

May 24, 2022 Excel Formulas

Often, we insert Carriage Return in Excel formula concatenate to make our data more comprehensible. We can insert a Carriage Return in formula ...

How to Concatenate Date That Doesn’t Become Number in Excel (5 Ways)

Mar 13, 2022 Excel Formulas

When your dataset has values like dates, numbers, texts etc. and you want to concatenate them, Excel throws some random numbers at you. To ...

How to Add Leading Zeros in Excel by CONCATENATE Operation

Jul 17, 2022 Excel Formulas

In Excel, if you insert a number with leading zeros, the zeros will disappear. Excel does that because normally zeros in front of a number don’t ...

How to Concatenate String and Variable in Excel VBA (A Detailed Analysis)

Mar 14, 2022 Macros & Excel VBA

While working with VBA in Excel, we often have to concatenate string (s) and variable (s) in a worksheet. Concatenating string (s) and variable (s) ...

How to Concatenate and Keep Currency Format in Excel (3 Methods)

Jul 24, 2022 Excel Formulas

While concatenating two or more pieces of text in Excel, you will find that the different number formats like currency, decimal format, and ...

Macro to Concatenate Multiple Columns in Excel (with UDF and UserForm)

Mar 14, 2022 Macros & Excel VBA

While working with VBA in Excel, we often have to develop Macro (s) to concatenate multiple columns in a worksheet. Concatenating columns is widely ...

How to Concatenate Multiple Cells With Space in Excel (7 Methods)

May 25, 2022 Excel Formulas

When dealing with Microsoft Excel, we occasionally need to concatenate multiple cells with their values using Excel formulas. We can easily ...

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

How to Concatenate Two Columns in Excel with Hyphen (9 Quick Ways)

May 25, 2022 Excel Formulas

If you are looking for some of the easiest ways to concatenate two columns in Excel with hyphen, then you will find this article useful. So, let’s ...

How to Concatenate Numbers with Leading Zeros in Excel (6 Methods)

Jul 17, 2022 Excel Formulas

Excel is undoubtedly one of the most useful and mostly used tools. We can take the help of Excel to do so many things in many ways. For example, in ...