Join Parts of a List With a Single Formula in Excel - (1 Minute Tutorials)

The Excel VBA/Macro Course [On Sale!]: www.teachexcel...
Download the File: www.teachexcel...
How to quickly combine any part of an entire list of values into a single value in a single cell.
This tutorial combines multiple text manipulation functions and shows you how they work together to make a single formula that saves you time!
Resources:
TeachExcel Online Courses: www.teachexcel...
TextJoin in Excel (Microsoft): support.micros...
Text Functions in Excel (Microsoft): support.micros...
#msexcel #tutorial #exceltips #freetutorial #exceltips #excel

[@nadermounir8228]

Thank you for this nice tutorial :)

[@leandroaugustorodriguesbar7809]

Thank you so!!!!

[@dhr.gilbert]

in my excel 2019, i have to enter this formula as array to get the same result as yours A1;A2 and so on