I am creating a database in Excel that requires an e-mail address to be assigned to each row or user. While some users have an e-mail address in the original CSV file the majority do not. Each e-mail address will need to be unique. Is there any way to auto-fill all blank cells with an e-mail address which starts with a higher number each time it's used for example [email protected], [email protected] etc etc...
1 Answer
If the email address you are going to autofill wouldn't have any significance, and you just want them to be unique, you can use the row number to make up an email address. One possible formula you can use is as follows,
=ROW()&"[email protected]"
If the above formula is used in 10th row, it would produce [email protected]
.
-
-
@Eddyy if this solves your problem, go ahead and click the check mark next to it to mark the question as solved. Oct 13, 2014 at 11:16
-