+ Post New Thread
Results 1 to 6 of 6
Office Software Thread, Excel expanding range thing question in Technical; I use Excel to create CSV files for temporary logins One column I need is login1@domain.ac.uk login2@domain.ac.uk etc If I ...
  1. #1

    Join Date
    Jan 2007
    Posts
    982
    Thank Post
    12
    Thanked 48 Times in 28 Posts
    Rep Power
    25

    Excel expanding range thing question

    I use Excel to create CSV files for temporary logins

    One column I need is login1@domain.ac.uk login2@domain.ac.uk 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?

  2. #2
    RichCowell's Avatar
    Join Date
    Dec 2005
    Location
    PR7, Lancashire
    Posts
    462
    Thank Post
    76
    Thanked 78 Times in 65 Posts
    Rep Power
    31
    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.

    Code:
    A B C
    login1 @domain.ac.uk =A1&$B$1
    login2 =A2&$B$1
    login3 =A3&$B$1
    or

    Code:
    A B C
    login1 @domain.ac.uk =A1&B1
    login2 @domain.ac.uk =A2&B2
    login3 @domain.ac.uk =A3&B3
    Last edited by RichCowell; 25th June 2014 at 09:12 AM.

  3. #3
    WayTooTricky's Avatar
    Join Date
    Jan 2014
    Location
    Reading
    Posts
    3
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    0
    Try this formula

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

    Copy down as many time as you like

  4. Thanks to WayTooTricky from:

    spadam (26th June 2014)

  5. #4

    Join Date
    Jan 2013
    Location
    Switzerland
    Posts
    170
    Thank Post
    13
    Thanked 24 Times in 23 Posts
    Rep Power
    8
    =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.

  6. #5

    3s-gtech's Avatar
    Join Date
    Mar 2009
    Location
    Wales
    Posts
    2,830
    Thank Post
    146
    Thanked 574 Times in 518 Posts
    Rep Power
    154
    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
    Last edited by 3s-gtech; 27th June 2014 at 09:42 AM.

  7. #6

    3s-gtech's Avatar
    Join Date
    Mar 2009
    Location
    Wales
    Posts
    2,830
    Thank Post
    146
    Thanked 574 Times in 518 Posts
    Rep Power
    154
    ---duplicate post---

SHARE:
+ Post New Thread

Similar Threads

  1. Excel/Word VB Coding question
    By Stuart_C in forum Coding
    Replies: 7
    Last Post: 21st June 2013, 03:59 PM
  2. Expanding our IP range - possibly a stupid question
    By sidewinder in forum Wired Networks
    Replies: 4
    Last Post: 4th December 2012, 03:17 PM
  3. office for mac excel formula question.
    By russdev in forum Office Software
    Replies: 2
    Last Post: 9th May 2008, 11:51 AM
  4. Excel VBA Loop Question
    By vunsev in forum Coding
    Replies: 5
    Last Post: 11th April 2008, 08:08 AM
  5. Replies: 16
    Last Post: 4th April 2008, 02:53 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •