Use the TEXTJOIN function to combine data from multiple cells in Excel:
- Create the list of cells containing data that you want to combine.
 - Open the function wizard by typing in the =TEXTJOIN formula in the cell where you want to show the joined data.
 - Select the delimiter that will separate the pieces of data.
 - Choose which cells you want to join and click OK.
 - The TEXTJOIN function will display the joined data in the selected cell.
 
