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

Other People Are Reading

Instructions

    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 "Sample@email.com, ".

    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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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