How do I generate an email list from my worksheet?
 

How do I generate an email list from my worksheet?
 

On Sep 3, 10:02*pm, Kris wrote:


It depends on what you mean by an email list. If you want a long
string of text with a separator (like a semi-colon) between addresses
you can concatenate text using a formula in a new column. Here is the
assumption: you have a column (we'll pretend it's column A) that has
valid email addresses with no blank entries and a column header cell
in A1. In column B we could put a formula in cell B2 like this:
=$B1&$A2&"; "
Now if you paste this down column B, each row will add it's email
address onto the end of the string. If this isn't what you're looking
for, please clarify.

Good luck,
Brendon

How do I generate an email list from my worksheet?
 

Brendon,

What if I have many e-mail addresses in one cell,
how do I make a list out of it. I would want one e-mail
per cell, so that it can be saved as CSV.

Thanks.
Mukesh




" wrote:

On Sep 3, 10:02 pm, Kris wrote:


It depends on what you mean by an email list. If you want a long
string of text with a separator (like a semi-colon) between addresses
you can concatenate text using a formula in a new column. Here is the
assumption: you have a column (we'll pretend it's column A) that has
valid email addresses with no blank entries and a column header cell
in A1. In column B we could put a formula in cell B2 like this:
=$B1&$A2&"; "
Now if you paste this down column B, each row will add it's email
address onto the end of the string. If this isn't what you're looking
for, please clarify.

Good luck,
Brendon

How do I generate an email list from my worksheet?
 

Copy/paste into Notepad then save the file, change the extension from
TXT to CSV.

Mukesh wrote:

Brendon,

What if I have many e-mail addresses in one cell,
how do I make a list out of it. I would want one e-mail
per cell, so that it can be saved as CSV.

Thanks.
Mukesh




" wrote:


On Sep 3, 10:02 pm, Kris wrote:

It depends on what you mean by an email list. If you want a long
string of text with a separator (like a semi-colon) between addresses
you can concatenate text using a formula in a new column. Here is the
assumption: you have a column (we'll pretend it's column A) that has
valid email addresses with no blank entries and a column header cell
in A1. In column B we could put a formula in cell B2 like this:
=$B1&$A2&"; "
Now if you paste this down column B, each row will add it's email
address onto the end of the string. If this isn't what you're looking
for, please clarify.

Good luck,
Brendon

How do I generate an email list from my worksheet?
 

I have been doing that, but would be great making a macro work
to search, sort, list....

Thanks.
Mukesh


"Bob I" wrote:

Copy/paste into Notepad then save the file, change the extension from
TXT to CSV.

Mukesh wrote:

Brendon,

What if I have many e-mail addresses in one cell,
how do I make a list out of it. I would want one e-mail
per cell, so that it can be saved as CSV.

Thanks.
Mukesh




" wrote:


On Sep 3, 10:02 pm, Kris wrote:

It depends on what you mean by an email list. If you want a long
string of text with a separator (like a semi-colon) between addresses
you can concatenate text using a formula in a new column. Here is the
assumption: you have a column (we'll pretend it's column A) that has
valid email addresses with no blank entries and a column header cell
in A1. In column B we could put a formula in cell B2 like this:
=$B1&$A2&"; "
Now if you paste this down column B, each row will add it's email
address onto the end of the string. If this isn't what you're looking
for, please clarify.

Good luck,
Brendon

How do I generate an email list from my worksheet?
 

Why are all the e-mail addresses in a single cell in a worksheet in the
first place? Correct the reason that occurs and you won't have to do the
rest.

Mukesh wrote:

I have been doing that, but would be great making a macro work
to search, sort, list....

Thanks.
Mukesh


"Bob I" wrote:


Copy/paste into Notepad then save the file, change the extension from
TXT to CSV.

Mukesh wrote:


Brendon,

What if I have many e-mail addresses in one cell,
how do I make a list out of it. I would want one e-mail
per cell, so that it can be saved as CSV.

Thanks.
Mukesh




" wrote:



On Sep 3, 10:02 pm, Kris wrote:

It depends on what you mean by an email list. If you want a long
string of text with a separator (like a semi-colon) between addresses
you can concatenate text using a formula in a new column. Here is the
assumption: you have a column (we'll pretend it's column A) that has
valid email addresses with no blank entries and a column header cell
in A1. In column B we could put a formula in cell B2 like this:
=$B1&$A2&"; "
Now if you paste this down column B, each row will add it's email
address onto the end of the string. If this isn't what you're looking
for, please clarify.

Good luck,
Brendon

How do I generate an email list from my worksheet?
 

Copy pasted from cc field.



"Bob I" wrote:

Why are all the e-mail addresses in a single cell in a worksheet in the
first place? Correct the reason that occurs and you won't have to do the
rest.

Mukesh wrote:

I have been doing that, but would be great making a macro work
to search, sort, list....

Thanks.
Mukesh


"Bob I" wrote:


Copy/paste into Notepad then save the file, change the extension from
TXT to CSV.

Mukesh wrote:


Brendon,

What if I have many e-mail addresses in one cell,
how do I make a list out of it. I would want one e-mail
per cell, so that it can be saved as CSV.

Thanks.
Mukesh




" wrote:



On Sep 3, 10:02 pm, Kris wrote:

It depends on what you mean by an email list. If you want a long
string of text with a separator (like a semi-colon) between addresses
you can concatenate text using a formula in a new column. Here is the
assumption: you have a column (we'll pretend it's column A) that has
valid email addresses with no blank entries and a column header cell
in A1. In column B we could put a formula in cell B2 like this:
=$B1&$A2&"; "
Now if you paste this down column B, each row will add it's email
address onto the end of the string. If this isn't what you're looking
for, please clarify.

Good luck,
Brendon

How do I generate an email list from my worksheet?
 

In that case there should be semi colons, use Text to Columns.

Mukesh wrote:

Copy pasted from cc field.



"Bob I" wrote:


Why are all the e-mail addresses in a single cell in a worksheet in the
first place? Correct the reason that occurs and you won't have to do the
rest.

Mukesh wrote:


I have been doing that, but would be great making a macro work
to search, sort, list....

Thanks.
Mukesh


"Bob I" wrote:



Copy/paste into Notepad then save the file, change the extension from
TXT to CSV.

Mukesh wrote:



Brendon,

What if I have many e-mail addresses in one cell,
how do I make a list out of it. I would want one e-mail
per cell, so that it can be saved as CSV.

Thanks.
Mukesh




" wrote:




On Sep 3, 10:02 pm, Kris wrote:

It depends on what you mean by an email list. If you want a long
string of text with a separator (like a semi-colon) between addresses
you can concatenate text using a formula in a new column. Here is the
assumption: you have a column (we'll pretend it's column A) that has
valid email addresses with no blank entries and a column header cell
in A1. In column B we could put a formula in cell B2 like this:
=$B1&$A2&"; "
Now if you paste this down column B, each row will add it's email
address onto the end of the string. If this isn't what you're looking
for, please clarify.

Good luck,
Brendon

How do I generate an email list from my worksheet?
 

Please elaborate.

Thanks.
Mukesh



"Bob I" wrote:

In that case there should be semi colons, use Text to Columns.

Mukesh wrote:

Copy pasted from cc field.



"Bob I" wrote:


Why are all the e-mail addresses in a single cell in a worksheet in the
first place? Correct the reason that occurs and you won't have to do the
rest.

Mukesh wrote:


I have been doing that, but would be great making a macro work
to search, sort, list....

Thanks.
Mukesh


"Bob I" wrote:



Copy/paste into Notepad then save the file, change the extension from
TXT to CSV.

Mukesh wrote:



Brendon,

What if I have many e-mail addresses in one cell,
how do I make a list out of it. I would want one e-mail
per cell, so that it can be saved as CSV.

Thanks.
Mukesh




" wrote:




On Sep 3, 10:02 pm, Kris wrote:

It depends on what you mean by an email list. If you want a long
string of text with a separator (like a semi-colon) between addresses
you can concatenate text using a formula in a new column. Here is the
assumption: you have a column (we'll pretend it's column A) that has
valid email addresses with no blank entries and a column header cell
in A1. In column B we could put a formula in cell B2 like this:
=$B1&$A2&"; "
Now if you paste this down column B, each row will add it's email
address onto the end of the string. If this isn't what you're looking
for, please clarify.

Good luck,
Brendon

How do I generate an email list from my worksheet?
 

Datatext to columns use semi colon as delimiter


--


Regards,


Peo Sjoblom




"Mukesh" wrote in message
...
Please elaborate.

Thanks.
Mukesh



"Bob I" wrote:

In that case there should be semi colons, use Text to Columns.

Mukesh wrote:

Copy pasted from cc field.



"Bob I" wrote:


Why are all the e-mail addresses in a single cell in a worksheet in the
first place? Correct the reason that occurs and you won't have to do
the
rest.

Mukesh wrote:


I have been doing that, but would be great making a macro work
to search, sort, list....

Thanks.
Mukesh


"Bob I" wrote:



Copy/paste into Notepad then save the file, change the extension from
TXT to CSV.

Mukesh wrote:



Brendon,

What if I have many e-mail addresses in one cell,
how do I make a list out of it. I would want one e-mail
per cell, so that it can be saved as CSV.

Thanks.
Mukesh




" wrote:




On Sep 3, 10:02 pm, Kris wrote:

It depends on what you mean by an email list. If you want a long
string of text with a separator (like a semi-colon) between
addresses
you can concatenate text using a formula in a new column. Here is
the
assumption: you have a column (we'll pretend it's column A) that
has
valid email addresses with no blank entries and a column header
cell
in A1. In column B we could put a formula in cell B2 like this:
=$B1&$A2&"; "
Now if you paste this down column B, each row will add it's email
address onto the end of the string. If this isn't what you're
looking
for, please clarify.

Good luck,
Brendon

How do I generate an email list from my worksheet?
 

Thank you.


Mukesh


"Peo Sjoblom" wrote:

Datatext to columns use semi colon as delimiter


--


Regards,


Peo Sjoblom




"Mukesh" wrote in message
...
Please elaborate.

Thanks.
Mukesh



"Bob I" wrote:

In that case there should be semi colons, use Text to Columns.

Mukesh wrote:

Copy pasted from cc field.



"Bob I" wrote:


Why are all the e-mail addresses in a single cell in a worksheet in the
first place? Correct the reason that occurs and you won't have to do
the
rest.

Mukesh wrote:


I have been doing that, but would be great making a macro work
to search, sort, list....

Thanks.
Mukesh


"Bob I" wrote:



Copy/paste into Notepad then save the file, change the extension from
TXT to CSV.

Mukesh wrote:



Brendon,

What if I have many e-mail addresses in one cell,
how do I make a list out of it. I would want one e-mail
per cell, so that it can be saved as CSV.

Thanks.
Mukesh




" wrote:




On Sep 3, 10:02 pm, Kris wrote:

It depends on what you mean by an email list. If you want a long
string of text with a separator (like a semi-colon) between
addresses
you can concatenate text using a formula in a new column. Here is
the
assumption: you have a column (we'll pretend it's column A) that
has
valid email addresses with no blank entries and a column header
cell
in A1. In column B we could put a formula in cell B2 like this:
=$B1&$A2&"; "
Now if you paste this down column B, each row will add it's email
address onto the end of the string. If this isn't what you're
looking
for, please clarify.

Good luck,
Brendon