CONCAT Function Archives

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

Feb 8, 2023 Excel Basics

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)

Feb 2, 2023 Excel Formulas

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)

Jan 24, 2023 Excel Formulas

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)

Jan 3, 2023 Excel Basics

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)

Feb 27, 2023 Excel Formulas

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)

Feb 28, 2023 Excel Formulas

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)

Dec 29, 2022 Excel Formulas

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)

Jan 1, 2023 Excel Basics

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)

Jan 1, 2023 Excel Formulas

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)

Feb 27, 2023 Excel Formulas

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

Dec 28, 2022 Calculation with Excel Formulas

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)

Dec 29, 2022 Excel Formulas

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)

Feb 9, 2023 Excel Basics

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

Feb 7, 2023 Excel Formulas

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

Jan 16, 2023 Advanced 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 ...