How to Filter User IDs That Start with Specific Letters (e.g., 'ay') in Excel

How to Filter User IDs That Start with Specific Letters (e.g., 'ay') in Excel

Issue

How to filter User IDs in Excel that begin with "ay" (e.g., "ay12345"), especially when the column contains a mix of formats such as numbers, emails, and User IDs.


Resolution

To filter User IDs starting with "ay" in Excel:

  1. Select the column containing the User IDs (e.g., Column A).

  2. Enable Filtering:

    • Navigate to the Data tab on the ribbon.
    • Click on the Filter button (funnel icon).

  3. Set a Custom Filter:

    • Click the drop-down arrow in the header of the column where the User IDs are located.
    • Hover over "Text Filters" and select "Begins With...".

  4. Specify the Condition:

    • In the "Begins With" pop-up box, type ay as the filter criteria.
    • Click OK to apply the filter.

  5. View Filtered Results:

    • Excel will now display only the rows where the User IDs start with "ay".

    • Related Articles

    • Merging User Accounts with User ID Migration

      Merging User Accounts with User ID Migration Introduction: This article explains how administrators can merge user accounts using the User ID Migration feature within the User Manager. This method allows you to transfer a user's records from one ...

    • How to generate ALL the users’ records based on ORGANIZATION

      How to generate ALL the users’ records based on ORGANIZATION If standard report does not meet your requirements or the specific fields that you want to see is not displayed on standard report, custom report maybe the solution. Below are the steps on ...

    • Resolution Report for Version 22.11

      Resolution Report for Version 22.11 The attached document lists all the bug fixes that have been addressed in Version 22.11.  Please review and advise the Peak Pacific team if you would like to upgrade your LMS. Peak Pacific Admin Team

    • Resolution Report for Version 22.7

      The attached document lists all the bug fixes that have been addressed in Version 22.11.  Please review and advise the Peak Pacific team if you would like to upgrade your LMS. Peak Pacific Admin Team

    • Resolution Report for Version 22.7

      The attached document lists all the bug fixes that have been addressed in Version 22.7.  Please review and advise the Peak Pacific team if you would like to upgrade your LMS. Peak Pacific Admin Team