Create an +1 formula

I need to create an excel list in the following format: mail1@domain.com mail2@domain.com and so on . . how can I quickly create a row list of 5000 like that quickly?
Starquest321Asked:
Who is Participating?
 
barry houdiniCommented:
You can put this formula in A2 and copy down to generate successive numbers

="mail"&ROWS(A$2:A2)&"@domain.com"

If you want to convert the list to fixed values rather than formula generated values then select column > Copy > Paste Special > Values > OK > ESC

regards, barry
0
 
barry houdiniCommented:
Note: for 5000 rows this way avoids "copying down"

Put suggested formula in A2
in box above A1 type in the range you want, e.g. A2:A5000 > Press ENTER to select that range > CTRL+D to fill the formula into that range

regards, barry
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.