autofilling a series of email addresses

[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....

(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
.....
.....
.....
.....
.....
(e-mail address removed)

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 (e-mail address removed) all the way to
(e-mail address removed). I am stuck. Any suggestions would
help...thnak you.

 

[Andy B]

Hi

Try something like:
=HYPERLINK(ROW()&"@email.com")
which you can fill down.

 

[Frank Kabel]

Hi
try the formula
=ROW(1:1) & "@email.com"

and copy this formula down

 

[Guest]

Andy, thanks but How do I have excel create this series
for me. In otherwords, I want it to create the next dummy
email for me. i entered (e-mail address removed), (e-mail address removed),
(e-mail address removed), (e-mail address removed) in fields A2,A3,A4,A5
respectively. Now I want excel to automatically with a
formula to put the next email address field of
(e-mail address removed) all the way to (e-mail address removed) or field
A13501. Not sure if I can do but I definitely appreciate
all your help.

Steve

 

[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

 

[Guest]

Thanks Andy, ignore previous posting. You rock. It works.
Steve

 

[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)

 

[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)