generate fake emails for Wordpree on 36,000 names

This may be an excel macro. Yes, I meant Wordpress.
I want to create 36000 users for Wordpress from and excel csv sheet, so I need to create fake emails for an import.

I'd probably want to use columun 1 customer number rather than concatenated first and last name which will produce duplicates.

Do I need a macro and what would it look like? cust#@xyz.com

How about just a formula?

	A	B
1	[email protected]	A1: ="customer" & ROW() & "@xyz.com"
2	[email protected]
3	[email protected]
4	[email protected]
5	[email protected]
6	[email protected]
7	[email protected]
8	[email protected]
9	[email protected]
10	[email protected]
11	[email protected]
12	[email protected]

Yes.

Or select all of the cells, paste the formula in the formula bar, press and hold the Ctrl key, the press Enter.

you can also try in "B2"
=MID(A2,FIND("@",A2)+1,256) & copy paste down till end.