Excel expanding range thing question

[googlemad]

I use Excel to create CSV files for temporary logins

 

One column I need is [email protected] [email protected] etc

 

If I just put login1 and double click the bottom right of the cell it populates the column with login2 login3 etc fine. But if I add the @domain.ac.uk bit at the end it doesn't work! Which wouldn't usually be a huge issue as it would be a small amount of temporary logins but this time 250 are required!!!

 

Any ideas?

[RichCowell]

I usually put the username in one column, then the rest of the email address in another column (or just one in a cell) then put a formula in a third column saying e.g.

 

[TABLE="width: 200"]
[TR]
[TD]A[/TD]
[TD]B
[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]login1[/TD]
[TD]@domain.ac.uk
[/TD]
[TD]=A1&$B$1[/TD]
[/TR]
[TR]
[TD]login2[/TD]
[TD][/TD]
[TD]=A2&$B$1[/TD]
[/TR]
[TR]
[TD]login3[/TD]
[TD][/TD]
[TD]=A3&$B$1[/TD]
[/TR]
[/TABLE]

 

or

 

[TABLE="width: 200"]
[TR]
[TD]A[/TD]
[TD]B
[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]login1[/TD]
[TD]@domain.ac.uk[/TD]
[TD]=A1&B1[/TD]
[/TR]
[TR]
[TD]login2[/TD]
[TD]@domain.ac.uk[/TD]
[TD]=A2&B2[/TD]
[/TR]
[TR]
[TD]login3[/TD]
[TD]@domain.ac.uk[/TD]
[TD]=A3&B3[/TD]
[/TR]
[/TABLE]

Edited June 25, 2014 by RichCowell

[WayTooTricky]

Try this formula

 

="login" & ROW() &"@domain.ac.uk"

 

Copy down as many time as you like

[jallsop]

=CONCATENATE(A1,B1)

I use this all the time for lists for e mail addresses etc.

 

interestingly, just tried to type @domain.com into Excel 2011 for mac, and as soon as you type @, the count if formula becomes active.

[3s-gtech]

Shows what an Excel noob I am - I create the list of login1, login 2 etc in one column with atschool.sch.uk in the next, save it as CSV, then use Notepad with Find and Replace to remove the comma! Works though Edited June 27, 2014 by 3s-gtech

[3s-gtech]

---duplicate post---