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.