+ Reply to Thread
Results 1 to 5 of 5

Have a massive list of employee names, positions, managers (eventual AD intergration)

  1. #1
    Registered User
    Join Date
    12-20-2022
    Location
    Buffalo, NY
    MS-Off Ver
    2010
    Posts
    2

    Post Have a massive list of employee names, positions, managers (eventual AD intergration)

    I cant post the actual file because of PHI, but here's an example of what I am working with

    Column A " 12123232132BuildingLocation "Last Name"
    Column B First Name and middle initial "1234435235325423- Building Location"LastName
    Column C Managername "

    The only data I need to extract from this is the employees first name, last name, and manager name.

    How can I do this?

    **the numbers are just various employee ID numbers and codes"

    Thanks in advance

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Have a massive list of employee names, positions, managers (eventual AD intergration)

    We do not need (or want) to see confidential information. Just make up a few represnetative rows in an Excel file, with expected results.

    That way, any ambiguity in your request is removed.

    The yellow banner (top) tells you how to post sample files.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    12-20-2022
    Location
    Buffalo, NY
    MS-Off Ver
    2010
    Posts
    2

    Re: Have a massive list of employee names, positions, managers (eventual AD intergration)

    A B C

    123445Building A.Smith "Johnny ""1234567819102070 - Employee Title Here"" McBoss" "Bossy ""Building A Regular (Full-Time)"

    I have about 15,000 rows of the above format. This is what I want to extract from the list: Smith, Johnny Employee Title Bossy McBoss

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Have a massive list of employee names, positions, managers (eventual AD intergration)

    That is NOT an Excel sheet. I do not know what is in which cell. Please post an Excel sheet which EXACTLY reflects the punctuation used in a REPRESENTATIVE sample (not 1 row) of your real data.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Have a massive list of employee names, positions, managers (eventual AD intergration)

    For example... in your intial post, you suggested that there was a space between building location and Last Name. Now you suggest that it's a full stop. Which is it?

    " 12123232132BuildingLocation "Last Name"
    23445Building A.Smith "Johnny ""1

    Are the " really present? Hard to tell as there's only ONE here:

    Column C Managername "


    These are the patterns that we need to exploit. That's why we need REPRESENTATIVE data in an Excel sheet....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to help sort employee results by Positions
    By mrteater in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-04-2020, 05:46 PM
  2. [SOLVED] Locate the 25 positions of the letters of the 4 blocks Each block has 25 positions
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 50
    Last Post: 12-22-2017, 12:46 PM
  3. How to group and display employee names - dynamic list
    By nitin.asalkar in forum Excel General
    Replies: 1
    Last Post: 01-20-2017, 05:26 AM
  4. Ipad excel docx intergration
    By sam46 in forum Excel General
    Replies: 0
    Last Post: 10-24-2012, 07:52 AM
  5. Showing list of managers depending on department
    By dalew in forum Excel General
    Replies: 2
    Last Post: 03-01-2011, 03:13 AM
  6. Excel & Mapoint vba code intergration question
    By lilsnoop in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2009, 10:46 PM
  7. Excel macro/function like VLOOKUP that sums eventual multiple matches
    By Mary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2006, 11:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1