Concatenation
By Richard Rost

5 years ago

Quickly join two cells together in Microsoft Excel

S M L XL FS | Slo Reg Fast 2x | Bookmark

In this video, I'll show you how to quickly join two cells together in Microsoft Excel using Concatenation.

Learn More!

Questions?

Please feel free to post your questions or comments below. Thanks.

Keywords

#msexcel, #microsoftexcel, #microsoft excel, #excel, #exceltips, concatenation, concatenate

Comments for Concatenation

Age	Subject	From
2 years	Concatenation in Excel	BJ Schroeder

Subscribe to Concatenation
Get notifications when this page is updated

Intro

In this video, we will learn how to join two cells together in Microsoft Excel using concatenation. I'll show you step by step how to combine a first name and last name into a single cell, enter the correct formula using the ampersand operator, autofill the new values down the column, and adjust the column width to fit your data.

Transcript

Welcome to another Excel Fast Tip brought to you by AcceleratingZone.com. I am your instructor, Richard Rost.

Today, I'm going to show you how to join two cells together using concatenation.

You have two cells, first name and last name, and you want to join them together for whatever reason. Maybe you want to use them in a mail merge in Word, and you want those in the same cell.

I'm going to click here on cell C1. I'm going to type in equals. It's how we start every formula: A1, ampersand, quote, space, quote, ampersand, B1, and then press enter. That joins those two together using something called concatenation.

Now, click on C1 again and double click here on the autofill handle. That will fill that down the whole column. Then, double click here on the column border. That will widen out that column as it needs to be to fit that data.

And that is concatenation.

Want to learn more Excel? Visit my website for many more free videos, including an hour-long beginner Excel course.

Quiz

Q1. What is the purpose of concatenation in Excel as described in the video?
A. To join the contents of two or more cells together
B. To format numbers as currency
C. To sort data from largest to smallest
D. To create charts from data

Q2. Which symbol is used in Excel formulas for concatenation as demonstrated in the video?
A. Plus sign (+)
B. Ampersand (&)
C. Forward slash (/)
D. Asterisk (*)

Q3. What is the correct formula to join first name in cell A1 with last name in cell B1, separated by a space?
A. =A1+B1
B. =A1&" "&B1
C. =A1," ",B1
D. =A1 B1

Q4. What is the function of double-clicking the autofill handle in Excel?
A. To delete the contents of a cell
B. To open the formatting options
C. To fill the formula down the column automatically
D. To filter data in the column

Q5. What does double-clicking the column border do in Excel?
A. Deletes the entire column
B. Changes the column's color
C. Adjusts the column width to fit the data
D. Sorts the column alphabetically

Answers: 1-A; 2-B; 3-B; 4-C; 5-C

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Excel Learning Zone covers how to join two cells together in Microsoft Excel by using concatenation.

Suppose you have a first name in one cell and a last name in another, and you want to combine them into a single cell. This is useful if you want to prepare data for a mail merge in Word or just need a full name together in one column.

To accomplish this, select cell C1 and start by entering the formula. All formulas in Excel begin with an equals sign. Combine the contents of cell A1, then a space, and then cell B1 by using the ampersand symbol and quotation marks for the space. Once you press enter, Excel will display the joined names in C1.

To apply this formula to an entire column, select C1 again and double-click the autofill handle, which will copy the formula down the column. If the new column isn't wide enough to show the full names, double-click the border of the column header to automatically adjust its width.

This process is called concatenation, and it is a simple and powerful tool for combining cell contents in Excel.

If you are interested in learning more about Excel, I invite you to visit my website where you can find many more free video tutorials, including a full beginner course. You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

Joining two cells using concatenation
Using ampersand to combine text in Excel
Adding a space between concatenated cells
Autofilling concatenation formula down a column
Adjusting column width to fit concatenated data

Links

Learn More!

Questions?

Keywords