Create Keyword Tags for Listing
I need to join a list of 'SEO Keywords' into a single comma-separated string for the backend search terms.
=TEXTJOIN(", ", TRUE, A2:A4) How it works: The TEXTJOIN function is perfect for concatenating text from multiple cells with a specified delimiter. The first argument `", "` sets the delimiter as a comma followed by a space, which is standard for keyword lists. The second argument `TRUE` ensures that any empty cells within your keyword range are ignored, preventing extra delimiters. Finally, `A2:A4` specifies the range containing all your individual SEO keywords that need to be combined.
Data Setup
| SEO Keywords |
|---|
| red dress |
| summer fashion |
| women's apparel |
Step-by-Step Guide
Open your Excel sheet containing your SEO keywords.
Assume your keywords are in cells A2, A3, and A4.
Select the cell where you want the combined keyword string to appear (e.g., B2).
Enter the formula: `=TEXTJOIN(", ", TRUE, A2:A4)`
Press Enter to see the combined string, ready to be copied into your Amazon Seller Central listing.