How to Add a Comma to an Excel Email List

Written by rebecca johnson
  • Share
  • Tweet
  • Share
  • Email

You can add a comma to an e-mail list in Microsoft Excel as long as your e-mail addresses are listed in separate, concurrent cells, such as a row or a column. You add commas by using a function called "CONCATENTATE." Once you add a comma to one e-mail address, you can use Excel's Auto Fill feature to copy the formula to the entire row or column.

Skill level:
Moderately Easy


    Add a Comma

  1. 1

    Click in an empty cell, preferably next to or below the cell that contains the first e-mail address in the list.

  2. 2

    Type "=CONCATENATE(Cell reference &", ")" with cell reference being the cell that contains the first e-mail address in the list. You should also press your "Spacebar" after typing the comma to ensure that your e-mail is separated by a comma and a space. For example, enter "=CONCATENATE(A2 & ",_")."

  3. 3

    Press "Enter" on your keyboard to complete the function. The cell returns the value of ", ".

    Auto Fill

  1. 1

    Click in the concatenated cell to select it.

  2. 2

    Place your mouse pointer over the small square in the lower-right corner of the cell. This square is called the "Fill Handle."

  3. 3

    Click and drag across or down the cells you want to fill. Excel automatically copies and updates the function into all the selected cells.

Tips and warnings

  • If you place the CONCATENATE function in concurrent rows or columns, you can double-click the "Fill Handle." Excel will automatically fill the cells until it reaches a blank cell in the concurrent row or column.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.