CONCATENATE Function

How to Concatenate Different Fonts in Excel (2 Easy Ways)

Many Excel users need to combine text from numerous cells into one cell where they use the Excel CONCATENATE function. However, you may want to ...

How to Merge and Center Selected Cells in Excel (4 Ways)

You may need to use the same values in some cells. In that case, you don’t need to insert the same cell value repeatedly, simply you can merge and ...

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 Find Distance Between Zip Codes in Excel Using Formula

In this tutorial, I am going to show you 2 easy methods of how to find the distance between zip codes in Excel using a formula. You can quickly use ...

How to Calculate Vector Multiplication in Excel (2 Useful Examples)

For scientific analysis we may have to calculate vector multiplication. We can use the Excel spreadsheet for this multiplication. In this article, we ...

How to Create Goal Thermometer in Excel (3 Effective Ways)

For analyzing and comparing data, Goal Thermometer is a wonderful tool for that. It helps to get a clear visualization of risk and achievement. In ...

How to Find Great Circle Distance Using Excel Formula

This tutorial will demonstrate how to find Great Circle Distance using the Excel formula. When we are dealing with the surface of a sphere, we need ...

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 Get All Combinations of 2 Columns in Excel (4 Easy Ways)

In this article, we will discuss how to get all combinations of 2 columns in Excel. Users often need to combine values of two columns to get an ...

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 Get a Text Box Linked to Cell in Excel (4 Examples)

If you are looking for ways to have a text box linked to a cell in Excel, then you will find this article helpful. The advantage of linking a cell ...

How to Add Prefix to Entire Column in Excel (4 Simple Methods)

Microsoft Excel is undoubtedly one of the most essential and valuable computer programs today. Using Excel's tools and features, we can do any number ...

How to Add Suffix in Excel (4 Easy Ways)

Microsoft Excel is undoubtedly one of the most essential and potent computer programs currently available. We can do unlimited calculations on any ...

Advanced Excel Exercises with Solutions PDF