Do this..

Assuming column A as email id starting from A2

B2 (=A2&",")
B3 (=B2&A3&",")

Now drag the formula in cell B3 below in column B

do copy-> pastespecial -> values for the last cell in column B

You will have the information in the required format..

Nishant


On Jun 22, 9:37 pm, Harmeet Singh <harmeet.hew...@gmail.com> wrote:
> Pleas see attached file
>
> On Mon, Jun 22, 2009 at 9:01 PM, Adam Lazzarato 
> <adam.lazzar...@gmail.com>wrote:
>
>
>
>
>
>
>
> > I have a 1400 row .csv file of emails.
>
> > A1 : abc...@hotmail.com
> > B1 : def...@yahoo.com
> > C1: ghi...@gmail.com
> > etc...
>
> > How would I go about concatenating the emails and separating them with
> > commas so I recieve:
>
> > abc...@hotmail.com,def...@yahoo.com,ghi...@gmail.com.... ETC
>
> > I am a rookie with hardcore excel functions, so thanks in advance for
> > your patience.
>
> > Thanks,
> > Adam
>
> --
> Thanks & Regards,
>
> Harmeet Singh
>
> Sent via BlackBerry Wireless
>
>  dsadsad.xls
> 31KViewDownload
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---

Reply via email to