Excel Formulas Archives - Page 132 of 149

How to Number Columns in Excel Automatically (3 Suitable Ways)

Jun 10, 2024

Here we have a data set with the sales record of some products for some years in a company. We'll enter values inside the row called Product No. to ...

How to Number Columns in Excel Automatically (3 Suitable Ways)

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)

Combine Multiple Cells into One Separated by Comma in Excel

Jun 30, 2024

The sample dataset has a listing of products. We'll combine the products from the two columns into the fourth column, separating the values by a ...

Combine Multiple Cells into One Separated by Comma in Excel

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)

Merge Rows in Excel (Using Functions, Features and VBA)

Nov 11, 2025

This article will cover many essential methods to merge rows in Excel. We'll walk you through applying features and VBA for merging rows. You will ...

Merge Rows in Excel (Using Functions, Features and VBA)

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

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

How to Concatenate Date and Time in Excel – 4 Formulas

Aug 6, 2024

Formula 1 - Combining the CONCATENATE and TEXT Functions to Join Date and Time in Excel Columns B and C represent dates and times. In Column D, ...

How to Concatenate Date and Time in Excel – 4 Formulas

How to Concatenate Range in Excel (5 Useful Methods)

Jul 26, 2024

We’ve got a dataset with the Product ID and Product Name of some products of a company named Mars Group. The values are stored in the Cell range ...

How to Concatenate Range in Excel (5 Useful Methods)

How to Combine Multiple Columns into One Column in Excel

Jul 1, 2024

Method 1 - Using the CONCATENATE or CONCAT Function to Join Multiple Columns into One Column in Excel In the following picture, the three columns ...

How to Combine Multiple Columns into One Column in Excel

Opposite of Concatenate in Excel (4 Options)

Jun 17, 2024

Method 1 - Split Text into Multiple Cells with Formula In the following table, Column B contains five distinct cells, each of which contains ...

Opposite of Concatenate in Excel (4 Options)

How to Concatenate in Excel (5 Easy Methods)

Nov 11, 2025

One of the most important features of Excel is to collect and contain data from various places into a single cell. In other words, to concatenate. ...

How to Concatenate in Excel (5 Easy Methods)

How to Concatenate Two Columns in Excel – 2 Methods

Aug 2, 2024

This is the sample dataset. To concatenate the First Name and Last Name: Method 1. Combine Names in Two Columns ...

How to Concatenate Two Columns in Excel – 2 Methods

VLOOKUP Example Between Two Sheets in Excel

Jun 24, 2024

Example 1 - Using VLOOKUP Between Two Sheets in the Same Excel Workbook In the following picture, Sheet1 is representing some specifications of a ...

VLOOKUP Example Between Two Sheets in Excel

How to Add Numbers in Excel (5 Easy Ways)

Nov 11, 2025

While working in Excel, we often need to add numbers for various purposes. After creating a data set, you may feel to edit or add numbers within the ...

How to Add Numbers in Excel (5 Easy Ways)

How to Auto Populate from Another Worksheet in Excel

Jul 2, 2024

Method 1 - Linking Excel Worksheets to Auto Populate from Another Worksheet Sheet1 contains some specifications of smartphone models. In ...