CONCATENATE Function Archives

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

May 10, 2023

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 Concatenate Different Fonts in Excel (2 Easy Ways)

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

Feb 2, 2023

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 and Center Selected Cells in Excel (4 Ways)

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

Feb 8, 2023

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 Merge Multiple Cells in Excel (5 Suitable Ways)

How to Join Text in Excel (6 Effective Methods)

Feb 2, 2023

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

How to Find Distance Between Zip Codes in Excel Using Formula

Feb 27, 2023

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

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

Jan 29, 2023

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 Calculate Vector Multiplication in Excel (2 Useful Examples)

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

Jan 3, 2023

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 Create Goal Thermometer in Excel (3 Effective Ways)

How to Find Great Circle Distance Using Excel Formula

Jan 4, 2023

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 Find Great Circle Distance Using Excel Formula

How to Join Names in Excel (7 Quick Methods)

May 10, 2023

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

Excel Join Formula (8 Practical Examples)

May 10, 2023

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

Excel Join Formula (8 Practical Examples)

How to Get All Combinations of 2 Columns in Excel (4 Easy Ways)

Jan 1, 2023

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

How to Concatenate with Delimiter in Excel (5 Easy Ways)

Dec 29, 2022

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

How to Get a Text Box Linked to Cell in Excel (4 Examples)

Jan 2, 2023

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

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

Jan 1, 2023

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 Prefix to Entire Column in Excel (4 Simple Methods)

How to Add Suffix in Excel (4 Easy Ways)

Jan 1, 2023

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