> 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 A
=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 wrote:
> Pleas s
e all 1400 rows, fit them all into one cell, and
separate with commas.
Thanks for your patience.
Adam
On Jun 22, 12:37 pm, Harmeet Singh wrote:
> Pleas see attached file
>
> On Mon, Jun 22, 2009 at 9:01 PM, Adam Lazzarato
> wrote:
>
>
>
>
>
> > I have a 1400 row .c
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