> 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
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,&
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
Hi Adam,
Do you really want 1400 email addresses all in one cell? I'm not sure if
they'll fit...
For some reason, the CONCATONATE worksheet function doesn't allow CONCAT(A1:A50)
The concatenation can be done easily in VBA, but what you want done with the
final result is another matter.
Regar
=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 see attached file
>
> On Mon, Jun 22, 2009 at 9:01 PM, Adam Lazzarato
>
Sorry, but unless I did something incorrectly, I am not sure this is
what I was looking for.
When you say 'paste into filed' I am not sure what you mean, so I just
pasted the data range B2:B28 into a word document, and the data didn't
show up how I expected.
I am trying to take all 1400 rows, fi
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 t
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
Pleas see attached file
On Mon, Jun 22, 2009 at 9:01 PM, Adam Lazzarato 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 re
