+ Post New Thread
Results 1 to 5 of 5
Office Software Thread, Generating usernames in Excel in Technical; Hi All, Hope we have an Excel expert who can help.. I need to redo all user accounts (long story) ...
  1. #1

    Join Date
    Jun 2010
    Location
    Cardiff
    Posts
    79
    Thank Post
    35
    Thanked 3 Times in 3 Posts
    Rep Power
    9

    Generating usernames in Excel

    Hi All,

    Hope we have an Excel expert who can help..

    I need to redo all user accounts (long story)

    Can anyone tell me please how i can get Cell 1 (Reg) Cell 2 (Forname) Cell 3 (Surname) to show as: (Reg)(1st initial)(surname)

    been trying Cell1+Cell2(char(1)+Cell3 but cant seem to get it right.

    Many thanks as always!

  2. #2

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,576
    Thank Post
    722
    Thanked 1,684 Times in 1,499 Posts
    Rep Power
    432
    needs to be left(cell2,1)

    Ben

  3. #3

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,576
    Thank Post
    722
    Thanked 1,684 Times in 1,499 Posts
    Rep Power
    432
    To concatenate use & not +

    Ben

  4. #4

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,576
    Thank Post
    722
    Thanked 1,684 Times in 1,499 Posts
    Rep Power
    432
    Code:
    =Cell1&left(Cell2,1)&Cell3
    Ben

  5. Thanks to plexer from:

    richbrowncardiff (8th September 2012)

  6. #5

    Join Date
    Jun 2010
    Location
    Cardiff
    Posts
    79
    Thank Post
    35
    Thanked 3 Times in 3 Posts
    Rep Power
    9
    Thank you thats great !

SHARE:
+ Post New Thread

Similar Threads

  1. Flash Embedded in Excel Documents
    By BKGarry in forum How do you do....it?
    Replies: 1
    Last Post: 2nd February 2010, 06:43 PM
  2. generate a list of usernames in active directory
    By mrstephenw in forum Windows Server 2000/2003
    Replies: 6
    Last Post: 14th December 2009, 12:42 PM
  3. Flash embedded in Excel
    By mitchell1981 in forum Windows
    Replies: 2
    Last Post: 21st November 2007, 10:07 AM
  4. need to extract text from a string in excel
    By projector1 in forum How do you do....it?
    Replies: 7
    Last Post: 14th February 2007, 01:41 PM
  5. Web query in Excel
    By pinemarten in forum How do you do....it?
    Replies: 2
    Last Post: 20th January 2006, 09:22 AM

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
  •