Hey Adam,
Use this function to concatenate multiple rows.
Alt + F11 to open the VB editor
Insert\Module
Paste the code below in the edit window
Then put this formula in any cell
=CommaCon(A1:A4)
Code Starts Here
Function CommaCon(rng As Range) As String
'
' CommaCon Function
'
Dim Temp As String
Temp = ""
For Each Cell In rng
Temp = Temp & Cell.Value & ", "
Next Cell
CommaCon = Mid(Temp, 1, Len(Temp) - 2)
'
End Function
It should work :-)
Regards,
Rajesh Kunder
On Mon, Jun 22, 2009 at 11:41 PM, Adam Lazzarato
<adam.lazzar...@gmail.com>wrote:
>
> =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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
