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

### How to Use Join Formula in Excel (6 Practical Examples)

In this tutorial, I am going to show you 6 practical examples to use the join formula in Excel. 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 ...

### How to Concatenate ZIP Codes in Excel (3 Easy Methods)

ZIP Code is one kind of Postal Code that is used to identify and locate an address. To keep location data, we have to store ZIP code data frequently ...

### How to Create a Complex Formula in Excel (with Easy Steps)

You have come to the right place if you are looking for the answer or some unique tips to create a complex formula in Excel. This article will walk ...

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

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS