Solved

Exporting email column as a Comma Separated Values

Posted on 2014-03-14
4
173 Views
Last Modified: 2014-03-14
Hi Folks,

I have an excel column with email addresses. How do I convert the column into a format like this, so that I can copy and paste into an email.

rg@abc.com, ab@abc.com,tt@abc.com

Thanks

RG
0
Comment
Question by:rgarimella
4 Comments
 
LVL 14

Expert Comment

by:Juan Ocasio
ID: 39929407
You can select the column and then perform a  Text to Columns with a delimiter of comma
0
 
LVL 8

Accepted Solution

by:
itjockey earned 500 total points
ID: 39929412
Assuming email addresses column is A with header.
Step 1 Formula in cell B2 =A2
Step 2 Formula in cell B3 =B2&","&A3
Step 3 Formula drop down
Done
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39929439
if your addresses are in Col A you can put this in B1
=A1 &","&A2&","&A3&","&A4

for sure you can add to as many rows as you have

if you have plenty then a small VBA can do it

Sub AddEmail()
Dim WS As Worksheet
Dim MaxRow As Long, I As Long

Set WS = ActiveSheet
MaxRow = WS.Range("A" & WS.Rows.Count).End(xlUp).Row

For I = 1 To MaxRow
    If WS.Cells(1, "B") <> "" Then WS.Cells(1, "B") = WS.Cells(1, "B") & ","
    WS.Cells(1, "B") = WS.Cells(1, "B") & WS.Cells(I, "A")
Next I
End Sub

Open in new window


check the file
gowflow
email.xls
0
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 39929448
Or as an UDF in VBA

Function fJoinEmails(rng As Range) As String
    fJoinEmails = Join(WorksheetFunction.Index(WorksheetFunction.Transpose(rng), 1, 0), ", ")
End Function

Open in new window

Regards
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now