CONCAT Function

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

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 Join Text in Excel (6 Effective Methods)

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 Do Union of Two Columns in Excel (5 Easy Ways)

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 Join Names in Excel (7 Quick Methods)

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

Excel Join Formula (8 Practical Examples)

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

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

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 Concatenate with Delimiter in Excel (5 Easy Ways)

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 Make Exponent in Excel Text (7 Easy Methods)

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 Find All Combinations of 1 Column in Excel (2 Handy Ways)

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 Add Prefix 0 in Excel (7 Easy Methods)

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

List of Names for Practice in Excel: 10 Exercises

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

Convert Number to Percentage Without Multiplying by 100 in Excel

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

How to Convert Column to Text with Delimiter in Excel

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 Concatenate If Cell Values Match in Excel (7 Easy Ways)

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 Cells with If Condition in Excel (5 Examples)

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo