Dear TLT: How do I Combine Text from Two Columns into One (in Excel)?

Dear TLT,

I’m working with a rather complex data set, and I need to combine text from two separate columns into one.  Is that possible?


Professor James Moriarty

Dear Professor Moriarty,

While it is not “elementary,” as some might say, it is definitely possible!  To get started, click on the first (empty) cell in the new column (C2 in the example below).


Click on Formulas > Insert > Text > CONCATENATE.


Click on cell A2 then type [, space“,].  Click on cell B2 and press enter.


Cell C2 should now include text from cells A2 and B2, but not R2D2 🙂


Use the fill handle to copy the formula to the rest of the cells in the new column.


Please contact your instructional technologist, if you have additional questions or concerns, and check out our upcoming training sessions at

Best regards,



Have a question for Dear TLT?  

Submit the following form to see it featured on our blog:

Professor James Moriarty is from what literary series? The first faculty member to email, with the correct answer, will receive a TLT flash drive!

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>