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

Rowby Goren
Rowby Goren used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Director of Solutions Consulting
Commented:
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.

Author

Commented:
Thanks!  Worked perfectly (of course!) :)

Rowby

Author

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
Aaron TomoskyDirector of Solutions Consulting

Commented:
Select the column, copy, paste special, values.

Author

Commented:
Thanks!  Special Values worked!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial