How to Combine Contents in Cells in Excel

click to begin

Youtube

Hi. In this Excel tutorial, we'll go over a few different ways to join cells in Excel. We'll join cells using Ampersand (&) and
CONCATENATE, and then CONCAT, which is an updated version of CONCATENATE and, lastly, we'll join cells using the TEXTJOIN
function. And, by the way, if you enjoy this tutorial, don't forget to Like the video and subscribe to the channel for even more tips.
Because & is a calculation operator and not a function, just select the cells that
you want to join and make sure to type the & between each cell and any delimiter. So, in this case, we're using a space as our delimiter, but
it can be any character or symbol. Making sure, again, to type the & between each one, and when you're done just select Enter.
Now, CONCATENATE works like the &, but given that it's a formula, we'll type in CONCATENATE and
select each cell that we want to join individually, adding our delimiter in quotation marks
between each item that we're joining.
CONCAT is an updated version of CONCATENATE, which will likely be phased out in the future. Now, what's great about
CONCAT is that you can select a range of cells at one time, rather than individually. So, in our example, we actually want
to insert a space as a delimiter between each item, but
let's say we didn't.
We can just select an entire range using CONCAT - which is something we're not able to do using
the & or CONCATENATE, we'd still have to go in and choose each item individually. Now, let's just
copy and paste over this so that it
looks correct with our space between each one.
And, lastly, TEXTJOIN. Now, TEXTJOIN is amazing! It functions very much like CONCAT, except that it can help you work faster. This
is because you can define your delimiter up front. So, in this case, we'll type our space delimiter.
We're going to choose to ignore empty cells. I mean, not that we have any empty cells in our range and there may be instances where you
want to include them, but I'm going to choose ignore for this example. And then we can just select our range of cells that we want to join.
And we'll copy this down.
So, I hope you found this tutorial on ways to join cells in Microsoft Excel helpful. If you enjoyed it, please make sure to Like the video
and don't forget to subscribe to this channel. Thanks!
How to Make a Map Chart in Excel - Tutorial How to Add Bulleted Lists in Excel - Tutorial How to Make a Password with Random Letters and Numbers in Excel - Tutorial Time Saving Excel Shortcuts - Tutorial How to Make a Calendar in Excel that Reveals a Picture - Tutorial How to Find Cells Used in Formulas in Excel - Tutorial

How to Combine Contents in Cells in Excel - Tutorial

Latest Posts