autofilling a series of email addresses

S

Steve

I need help. I have read some books and checked out the
appropiate sites but I can't seem to find the info I need.

Here's my problem....

[email protected]
[email protected]
[email protected]
[email protected]
.....
.....
.....
.....
.....
[email protected]

I am trying to autofill a column with "dummy" email
addresses like above (13,000 total from one of my contact
lists) in order to import this list into another program
as a tab delimited file. The other program requires an
email address in the first column in order to properly
upload the file. Is there any way to autofill column A
where it automatically calculates this series, without
having to manually enter [email protected] all the way to
[email protected]. I am stuck. Any suggestions would
help...thnak you.
 
G

Guest

F

Frank Kabel

Hi
put Andy's formula in yoúr first cell and simply copy this formula
down. No need for any other manual entries
 
P

Peo Sjoblom

One way

=HYPERLINK("mailto:"&LEFT(TRIM(A8),TRIM(FIND("@",A8)-1))+1&"@email.com",LEFT
(TRIM(A8),TRIM(FIND("@",A8)-1))+1&"@email.com")

add 1 per copied down row to what's in the previous row, in my example A8

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
P

Peo Sjoblom

You realize that it doesn't work as a genuine email link that will open your
email client? For that you'd need

=HYPERLINK("mailto:"&ROW()&"@email.com",ROW()&"@email.com")

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top