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 http://tlt.eventbrite.com.
Have a question for Dear TLT?
Submit the following form to see it featured on our blog:http://goo.gl/n1N2tq.
Professor James Moriarty is from what literary series? The first faculty member to email firstname.lastname@example.org, with the correct answer, will receive a TLT flash drive!