In this video we can learn about a Quick way to combine multiple text values is by using CONCAT() Function and TRANSPOSE Function. This Tutorial explains how to combine cells into one cell with semicolon, commas or space step by step.
2. This video also consist of use of "&" for concate different values in excel.
#ITTricksScroll