Concatenate Excel Archives - Page 3 of 4

How to Combine Names in Excel with Space (6 Approaches)

Jul 15, 2024

We are going to use a dataset containing the First Name and Last Name of Hollywood actors. We will combine the First Name and Last Name cells to have ...

How to Combine Names in Excel with Space (6 Approaches)

Excel VBA: Combine Date and Time (3 Methods)

Nov 11, 2025

While making a time log of activities in Excel, you may want to combine date and time. In most cases, you may have dates in one column and time in ...

Excel VBA: Combine Date and Time (3 Methods)

Excel INDEX MATCH to Concatenate Multiple Results (With 2 Easy Steps)

Nov 11, 2025

While working in Microsoft Excel we might need to concatenate different multiple results from a particular dataset. In this article, we will ...

Excel INDEX MATCH to Concatenate Multiple Results (With 2 Easy Steps)

How to Bold Text in a Concatenate Formula using VBA in Excel – 2 Methods

Aug 3, 2024

This is the sample dataset. Method 1 - Bold Text in the Output of the Concatenate Formula. Press ALT+F11 to open VBA. In the VBA window, ...

How to Bold Text in a Concatenate Formula using VBA in Excel – 2 Methods

Carriage Return in Excel Formula to Concatenate (6 Examples)

Jul 4, 2024

Method 1 - Using Ampersand Operator and CHAR Functions Insert Carriage Return in Excel Formula to Concatenate Step 1: Insert the following formula ...

Carriage Return in Excel Formula to Concatenate (6 Examples)

How to Concatenate Date That Doesn’t Become Number in Excel (5 Ways)

Jul 28, 2024

Method 1 - Concatenate a Date with Text and Keep the Date Format in Excel If you concatenate Text with Dates, then the Dates will be converted to ...

How to Concatenate Date That Doesn’t Become Number in Excel (5 Ways)

How to Add Leading Zeros in Excel by CONCATENATE Operation

Nov 11, 2025

In Excel, if you insert a number with leading zeros, the zeros will disappear. Excel does that because normally zeros in front of a number don’t ...

How to Add Leading Zeros in Excel by CONCATENATE Operation

How to Concatenate and Keep Currency Format in Excel (3 Methods)

Jun 18, 2024

While concatenating two or more pieces of text in Excel, different number formats like currency, decimal format, and percentage format are removed ...

How to Concatenate and Keep Currency Format in Excel (3 Methods)

How to Concatenate Numbers with Leading Zeros in Excel: 6 Methods

Jul 9, 2024

Method 1 - Using the CONCATENATE Function in Excel to Concatenate Numbers with Leading Zeros STEPS: Go to the Home tab. Select Number and ...

How to Concatenate Numbers with Leading Zeros in Excel: 6 Methods

Add Text and Formula in the Same Cell in Excel (4 Examples)

Jul 3, 2024

Example 1 - Add Text and Formula in the Same Cell in Excel with the Ampersand Operator We have an Income-Expense List has four columns. We have ...

Add Text and Formula in the Same Cell in Excel (4 Examples)

Why Concatenate Isn’t Working in Excel (3 Common Reasons and Solutions)

Jul 28, 2024

Dataset Overview We'll use the below dataset containing the lists of first names and last names to investigate why Concatenation is not working: ...

Why Concatenate Isn’t Working in Excel (3 Common Reasons and Solutions)

How to Concatenate Apostrophe in Excel: 6 Easy Methods

Jul 3, 2024

Method 1 - Using Ampersand Operator (&) to Concatenate Apostrophe Steps: Type the following formula in cell D5. ...

How to Concatenate Apostrophe in Excel: 6 Easy Methods

How to Concatenate Numbers in Excel (4 Quick Formulas)

Jul 5, 2024

In this article, we'll cover the methods and formulas to concatenate (or join together) numbers with different formats in Microsoft Excel. ...

How to Concatenate Numbers in Excel (4 Quick Formulas)

How to Combine Date and Text in Excel (5 Methods)

Jun 17, 2024

Method 1 - Using CONCATENATE or CONCAT Function to Combine Date and Text in Excel To maintain the proper format of a date or a time in a cell that ...

How to Combine Date and Text in Excel (5 Methods)

How to Concatenate with Space in Excel (3 Suitable Ways)

Jun 14, 2024

To demonstrate how to use the concatenate function, we will use a dataset with the First Name, Middle Name, and Last Name columns. We will apply ...