Extract a column of email addresses

[Waidesworld]

I have a column of email addresses and need to extract it to replace the row division with a comma. Is there an easy way to do this? I have tried with wordpad, notepad etc. and am getting nowhere.
_________________
Can your camera talk to your computer? We can make it happen...any camera, any computer

[RickRandom]

Not sure what you mean by "replace the row division with a comma".

Perhaps copy a few examples of what you have and what you want to get.

Maybe the REPLACE( ) function will do what you want?

[Waidesworld]

say column E reads

a@b.com
c@d.com
e@f.com

and I want to extract this data into a one liner for a mass email (not Spam, my customers)
to read
a@b.com, c@d.com, e@f.com
_________________
Can your camera talk to your computer? We can make it happen...any camera, any computer

[jrkrideau]

[JohnV]

You might also do a Transpose in Calc.

Select the addresses, copy and click in the first address (or any cell). Do Edit > Paste Special, check Transpose, click OK and then Yes, if the overwrite warning appears.

This won't get you a comma but will get the addresses in one row. Just thought I'd toss this in if you didn't know about Transpose.

[Waidesworld]

thing is, I know a lot of the moves but the Friday brain farting has got the better of me. Thanks for the reminders. I am set now.
_________________
Can your camera talk to your computer? We can make it happen...any camera, any computer

[David]

[quote="Waidesworld"]and I want to extract this data into a one liner for a mass email (not Spam, my customers)


You might try a better option: http://www.infacta.com . They have a free, and still very useful version. You can import email addresses ...read the instructions on that in the program. I use it to send a Christmas greeting to family and friends.

If it is for SPAM, I'll find out where you live

David.

[jrkrideau]