Creating a Comma Delimited List

This quick guide will show you how to create a comma-delimited list. This may be helpful for various functions within the ETC.

Step 1:

From your excel sheet, click on an open cell where you would like the information to populate

Arrow pointing to empty cell

Step 2:

Type in the following formula: =TEXTJOIN(",",true,A1:A6)

Substitute the A1:A6 for the range of your data


Highlight of Text Join formula

Step 3:

Hit enter, the data will populate in the cell

Highlight of populated cell

Step 4:

You can copy and paste the list into the comma-delimited field as needed