Hi Adam,

If you are using Excel 2007, This would be a task for some keystrokes....
You need to :
1. Copy the data and transpose entire data in a single row.
2. Copy the entire row and paste the data in a notepad.
3. In the notepad, copy blank space between e-mail IDs.
4. Press Ctrl+H and Paste the copied data in "find what" Box.
5. In the replace box, type a single ",".
6. Press Replace all and copy the whole data back to excel.

If you are using Excel 2003, you can do this in 5 Iterations.

Regards,

Upendra Singh
9910227325

----------------------------------------------------------------------------
---------------------------------
There are 10 kinds of people: Those who understand binary and those who
don’t.


-----Original Message-----
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Adam Lazzarato
Sent: Monday, June 22, 2009 11:42 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Concatenate cells and separate values with
commas


=concatenate(A1,",",A2)
Seems give the effect I am looking for. I just need a fast way to make
it...

=concatenate(A1,",",A2,",",A3,",A4,"," .... ",",A1399,",",A1400)

Adam

On Jun 22, 12: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