Solved

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

Posted on 2011-09-05
5
298 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

776 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