How do I use the CONCATENATE or TEXTJOIN function in Excel?

The following list outlines the steps for using CONCATENATE or TEXTJOIN:

1. To use CONCATENATE, click the CONCATENATE function in the formula bar and enter the range of cells or text you want to join
2. Edit the CONCATENATE function parameters to determine the order of elements and the separator to be used
3. To use TEXTJOIN, click the TEXTJOIN function in the formula bar and enter the range of cells or text you want to join
4. Edit the TEXTJOIN function parameters to determine the order of elements, the separator, and whether to ignore empty cells