November 3, 2009 in Uncategorized by Jerry


Has there ever been a time that you needed to add commas to a huge list of keywords (or maybe you needed to add a semi colon at the end of a list of e-mail addresses) and you wished there was a better way to do it than doing it manually?
Fortunately, there is a quick an easy way of adding commas to long list of keywords when you use Microsoft Excel. Here is how:

First, copy all of your keywords into column A.

Column A

Then, type in a comma in cell B2. Copy and paste cell B2 into all of the cells of column B.

Column B

In cell C1, type in this formula: =CONCATENATE(A1,B1)

Concatenate

Notice how Microsoft Excel is already adding the comma at the end of the keyword:

Concatenated

Now, simply copy and paste the contents of cell C1 into all of the cells in column 3.

Concatenated Results

Incoming search terms:

  • add commas to list

Tags

add comma, concatenate, concatenate function