+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Is this possible in Excel? in Technical; Hi, Just wondered if the following was possible in excel. Basically have a spreadsheet with three columns of data, users ...
  1. #1

    Join Date
    May 2007
    Location
    Brighton
    Posts
    92
    Thank Post
    56
    Thanked 9 Times in 6 Posts
    Rep Power
    16

    Is this possible in Excel?

    Hi,

    Just wondered if the following was possible in excel.

    Basically have a spreadsheet with three columns of data, users username for different system ,(ie email, network, sims etc)

    Is there a magic formula that can go through them all, and sort/put them together in a row.

    Currenty its about 80 rows:

    simsuser emailuser networkuser

    jsmith john.smith john smith
    dcameron david.cameron david cameron etc

    However some people dont have a email or sims account so doing an A-Z sort results in gaps and manually dragging cells across.

    eg

    simsuser emailuser networkuser

    jsmith john smith
    david.cameron david cameron etc

    Doing it to tidy up usernames and duplication etc in schools. Eventually will probably use it to migrate to Office365, but thats a different story!

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    I'm not sure I follow - you want all of the usernames for a person in one cell (regardless of how many usernames they have)?

    If that's what you're getting at, your formula would be something like

    Code:
    =trim(if(isblank(A1),"",A1)&" "&if(isblank(A2),"",A2)&" "&if(isblank(A3),"",A3))

SHARE:
+ Post New Thread

Similar Threads

  1. Is this possible - membership?
    By Diffie in forum EduGeek Joomla 1.5 Package
    Replies: 11
    Last Post: 16th March 2009, 01:07 PM
  2. Is this possible?
    By laserblazer in forum General Chat
    Replies: 6
    Last Post: 3rd January 2009, 03:51 AM
  3. New Mac network - is this possible?
    By sidewinder in forum Mac
    Replies: 28
    Last Post: 28th August 2008, 01:19 AM
  4. Replies: 1
    Last Post: 26th August 2008, 01:49 PM
  5. Is This Possible?
    By Gambit in forum Scripts
    Replies: 7
    Last Post: 18th April 2007, 09:36 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
  •