CONCAT Function Archives

How to Merge Multiple Cells in Excel (5 Suitable Ways)

Feb 8, 2023

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make ...

How to Merge Multiple Cells in Excel (5 Suitable Ways)

How to Join Text in Excel (6 Effective Methods)

Feb 2, 2023

While working in Excel, we often need to join multiple text strings together. Joining texts manually can be a time-consuming and inefficient way to ...

How to Join Text in Excel (6 Effective Methods)

How to Do Union of Two Columns in Excel (5 Easy Ways)

Jan 24, 2023

In Excel, we often need to do union of two columns. We can manually merge two columns in Excel. But for a large, this will require a lot of time. ...

How to Do Union of Two Columns in Excel (5 Easy Ways)

How to Join Names in Excel (7 Quick Methods)

May 10, 2023

Sometimes, you may need to join names in Excel. Suppose you have a dataset where the first and last names have existed separately. You need to join ...

How to Join Names in Excel (7 Quick Methods)

Excel Join Formula (8 Practical Examples)

May 10, 2023

In this tutorial, I am going to show you 8 practical examples of using the Excel join formula. You can quickly use these methods even in large ...

Excel Join Formula (8 Practical Examples)

How to Create Permutation Table in Excel (4 Easy Methods)

Feb 28, 2023

This tutorial will demonstrate how to determine Excel permutation table. We use the Permutation in Excel where in the data the order of the data ...

How to Create Permutation Table in Excel (4 Easy Methods)

How to Concatenate with Delimiter in Excel (5 Easy Ways)

Dec 29, 2022

Excel concatenation is a useful and frequently used feature. If you want to join or delimit text, this article might be useful to you. In this ...

How to Concatenate with Delimiter in Excel (5 Easy Ways)

How to Make Exponent in Excel Text (7 Easy Methods)

Jun 1, 2023

In this article, I will show how to make an exponent in Excel text by using 7 easy methods. You may need to do mathematical calculations when you ...

How to Make Exponent in Excel Text (7 Easy Methods)

How to Find All Combinations of 1 Column in Excel (2 Handy Ways)

Jan 1, 2023

In mathematics, calculating combinations of a certain number of characters is a very common practice. In fact, we can count these combinations in ...

How to Find All Combinations of 1 Column in Excel (2 Handy Ways)

How to Add Prefix 0 in Excel (7 Easy Methods)

Feb 27, 2023

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes we ...

How to Add Prefix 0 in Excel (7 Easy Methods)

List of Names for Practice in Excel: 10 Exercises

Dec 28, 2022 4

In this article, you will get a list of names for practice in an Excel file. To solve all the problems, you should have intermediate knowledge of ...

List of Names for Practice in Excel: 10 Exercises

Convert Number to Percentage Without Multiplying by 100 in Excel

Feb 7, 2023

The percentage is the fraction of two numbers multiplied by 100. Mathematically, we need to multiply a number by 100 to convert that into a ...

Convert Number to Percentage Without Multiplying by 100 in Excel

How to Convert Column to Text with Delimiter in Excel

Jan 16, 2023

We often need a list in a column in an Excel sheet to arrange in a horizontal orientation. We will need a delimiter to separate the texts in that ...

How to Convert Column to Text with Delimiter in Excel

How to Concatenate If Cell Values Match in Excel (7 Easy Ways)

Mar 14, 2023

If you want to represent the values that match certain criteria in a cell then this article will be helpful for you. The main objective of this ...

How to Concatenate If Cell Values Match in Excel (7 Easy Ways)

How to Concatenate Cells with If Condition in Excel (5 Examples)

Mar 14, 2023

Microsoft Excel is a wonderful tool that can help us not only with small spreadsheet stuff but also, with formulas, can automate too many processes ...