$$Excel-Macros$$ Re: Concatenate cells and separate values with commas

2009-06-23 Thread Adam Lazzarato
> 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

$$Excel-Macros$$ Re: Concatenate cells and separate values with commas

2009-06-22 Thread Adam Lazzarato
=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

$$Excel-Macros$$ Re: Concatenate cells and separate values with commas

2009-06-22 Thread Adam Lazzarato
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

$$Excel-Macros$$ Concatenate cells and separate values with commas

2009-06-22 Thread Adam Lazzarato
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