Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

CONCATENATE Function

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

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

How to Add Suffix Without Formula in Excel (2 Easy Methods)

There are many ways to add suffix in Excel. Out of those many ways, we will show you 2 easy ways to add suffix in Excel without formula. Isn't it the ...

ExcelDemy
Logo