Excel Combine Text from Multiple Columns
In this video, we go over 3 methods to combine text from multiple columns in Excel. The first uses Flash Fill, the second uses the concat() function, and the third, my favourite, uses the &.
To download a copy of the excel file used in this video, go over to
https://efficientanalyst.com/excel-co...
Chapters:
0:00 Introduction
0:27 Using Flash Fill
1:52 Using Concat()
3:37 Using "&"
4:16 Thank You
Efficient Analyst: https://www.EfficientAnalyst.com
Blog: http://www.studiojpic.com
Facebook: / studiojpic
Twitter: / studiojpic
Affiliates:
Amazon USA: http://www.amazon.com/?_encoding=UTF8...
Amazon Canada: http://www.amazon.ca/?_encoding=UTF8&...
Adorama: http://www.adorama.com/?KBID=67818
ebay: http://rover.ebay.com/rover/1/711-532...