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

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
LVL 9
Rowby GorenAsked:
Who is Participating?
 
Aaron TomoskyConnect With a Mentor SD-WAN SimplifiedCommented:
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
 
Rowby GorenAuthor Commented:
Thanks!  Worked perfectly (of course!) :)

Rowby
0
 
Rowby GorenAuthor Commented:
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
 
Aaron TomoskySD-WAN SimplifiedCommented:
Select the column, copy, paste special, values.
0
 
Rowby GorenAuthor Commented:
Thanks!  Special Values worked!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.