Solved

Column of fake email addresses - need to increment them with "01" "02" numbers

Posted on 2011-09-05
5
283 Views
Last Modified: 2012-05-12
Hi

I have an excel 2007 speadsheet.  I need to generate a column of email addresses in this format:

user01@test.com
user02@test.com
user03@test.com

Is there a command or a formula that will let me do this?

Thanks

Rowby
0
Comment
Question by:Rowby Goren
  • 3
  • 2
5 Comments
 
LVL 38

Accepted Solution

by:
Aaron Tomosky earned 500 total points
ID: 36484208
If you type user01 and drag down it will autoincrement for you. Then in the next column over let's call it b1: =a1&"@test.com"
Drag down.
0
 
LVL 9

Author Closing Comment

by:Rowby Goren
ID: 36484240
Thanks!  Worked perfectly (of course!) :)

Rowby
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 36484255
One quick follow up.   How do I make the contents of the new field permanent, so that I can delete the old user01 etc column -- so I don't need the reference any more.

Rowby
0
 
LVL 38

Expert Comment

by:Aaron Tomosky
ID: 36484300
Select the column, copy, paste special, values.
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 36484424
Thanks!  Special Values worked!
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now