Excel - auto-fill blank cells or 0 in B:B to a dummy e-mail address which changes sequentially

1

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 1example@example.com, 2example@example.com etc etc...

Eddyy

Posted 2014-10-13T10:26:05.487

Reputation: 128

Answers

1

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()&"example@example.com"

If the above formula is used in 10th row, it would produce 10example@example.com.

jjk_charles

Posted 2014-10-13T10:26:05.487

Reputation: 1 087

That's great, it works perfectly and is simple. Thanks! – Eddyy – 2014-10-13T11:02:10.513

@Eddyy if this solves your problem, go ahead and click the check mark next to it to mark the question as solved. – Raystafarian – 2014-10-13T11:16:43.400

Done - Thanks for the heads up I was not too sure. – Eddyy – 2014-10-13T11:23:15.733

Asked: 2014-10-13T10:26:05.487

Viewed: 174 times

Active: 2014-12-01T05:22:21.183