Skip to main content

How to use concatenate in Excel

The concatenate function may not be as well known as other common Excel features such as IF and VLOOKUP, but it’s still effective, even though it performs a more simple function in nature. Concatenate merges the data you have inserted into columns into its own cell or column. For example, you could combine columns detailing revenue and profit for a given month into one cell.

Let’s take a look at how to use concatenate in Excel.

Difficulty

Easy

Duration

5 minutes

What You Need

  • PC

  • Microsoft Excel

Using the concatenate function for two columns in Excel

Step 1: Select the column and cell in which you’ll be combining data from other cells. For demonstration purposes, I will be using concatenate in the column adjacent to the first two columns that I will be combining, but you can use any location within your spreadsheet.

Selecting a cell that will be used for the concatenate function.
Image used with permission by copyright holder

Step 2: I will be combining the A2 and B2 cells, so I’ve typed in =CONCATENATE(A2,B2). This is the most basic form of using the concatenate function, but there are ways to customize it, which we’ll go through in step 4.

Entering the concatenate formula into a cell in Excel.
Image used with permission by copyright holder

Step 3: To confirm the concatenate formula, just hit the enter key, after which the cells you’ve inserted into the formula will be joined.

How a cell looks after inputting the concatenate formula in Excel.
Image used with permission by copyright holder

Step 4: As you can see above, the standard concatenate formula I used combined my data but it doesn’t look quite right.

You may want to insert a space between the data that is being joined: Type in =CONCATENATE(A2, " ", B2).

If you want to add another value, simply type that in between the quotation marks within that formula. For example, you can separate the combined data with the equal sign.

I’ve added the equal sign and two additional spaces between it within the quotations marks to separate the data that has been merged.

Adding a space and equal sign within a concatenate formula in Excel.
Image used with permission by copyright holder

Step 5: You can further customize the cell where the concatenate function is being used by using the standard Excel tools. I’ve made it bold, centered the text, and increased the font size.

Applying further customization to a cell where the concatenate function has been applied.
Image used with permission by copyright holder

How do you concatenate 3 columns in Excel?

You can also use the concatenate function to combine more than two columns.

Step 1: I typed in =CONCATENATE(A2,B2,C2) into its own cell. Change the column letters to ones of your choosing, and then hit Enter.

The concatenate formula for combining three columns in Excel.
Image used with permission by copyright holder

Step 2: If you want to use concatenate for an entire column, Excel provides an easy solution. Just drag the first cell’s bottom-right corner that we filled in from step 1 using your mouse to wherever you wish the combined data to appear.

Applying the concatenate formula by dragging a cell in Excel.
Image used with permission by copyright holder

How do you concatenate in Excel without a formula?

Step 1: To concatenate cells in Excel without using its formula, enter, for example, =A2 & B2.

This will save you from entering the formula itself, which, in this case, would be =CONCATENATE(A2,B2).

Step 2: As is the case with confirming the concatenate formula, press the Enter button.

Applying the concatenate function in Excel without the formula.
Image used with permission by copyright holder

For more guides on Excel and its other functions, head over to our articles explaining how to make a graph and how to alphabetize data in a spreadsheet. You can also check out everything new in Microsoft Office.

Editors' Recommendations

Zak Islam
Computing Writer
Zak Islam was a freelance writer at Digital Trends covering the latest news in the technology world, particularly the…
GPT-4: how to use the AI chatbot that puts ChatGPT to shame
A laptop opened to the ChatGPT website.

People were in awe when ChatGPT came out, impressed by its natural language abilities as an AI chatbot. But when the highly anticipated GPT-4 large language model came out, it blew the lid off what we thought was possible with AI, with some calling it the early glimpses of AGI (artificial general intelligence).

The creator of the model, OpenAI, calls it the company's "most advanced system, producing safer and more useful responses." Here's everything you need to know about it, including how to use it and what it can do.
What is GPT-4?
GPT-4 is a new language model created by OpenAI that can generate text that is similar to human speech. It advances the technology used by ChatGPT, which is currently based on GPT-3.5. GPT is the acronym for Generative Pre-trained Transformer, a deep learning technology that uses artificial neural networks to write like a human.

Read more
How to use Meta Threads on the web
The login screen for the Threads desktop website.

Threads — Meta's answer to X, formerly known as Twitter — is now accessible via the web. Previously exclusive to a mobile app, you can now use Threads on your desktop, and in this guide, we'll show you how to navigate Threads' new desktop website.

Read more
How to use Microsoft Copilot in Teams, Powerpoint, Excel, and more
Using Windows 11 copilot to summarize a document.

The Windows 11 Copilot AI is Microsoft's big push to bring modern artificial intelligence to its flagship operating system — and it goes far beyond the early integrations of ChatGPT through Bing Chat. This isn't your granddad's Clippy, it's a whole new way of augmenting Windows with truly smart functions.

Here's how to use the Microsoft Copilot AI in Windows 11 to make your life easier and more efficient.

Read more