Solved

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

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

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 39

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

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…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

792 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