cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
To help support our community and customers during the outbreak of Coronavirus (COVID-19), LogMeIn is providing free Emergency Remote Work Kits for Health Care Providers, Educational Institutions, Municipalities, Non-Profit organizations, and current LogMeIn customers. For more information please visit https://www.gotomeeting.com/work-remote
Highlighted
Contributor

Using Email Domain to Sort by Organization

In case this helps anyone else.... my webinars are for state government and attendees can type their organization name many different ways, depending on abbreviations, if they include the state first, etc. This makes it hard view a roster and determine how many from each or how many organizations served. 

After downloading registration or attendee list to Excel, I copy the email column, rename the new column "Domain" and use search/replace to strip off the username text and @. (Search for *@ and leave "replace" field empty.) Then I can sort by domain and have the list grouped by organization.

Occasionally someone will use their personal email, but that's pretty rare. So this helps us when we need to track organizations.

And if we need to standardize the organization name in the spreadsheet, it's much faster to edit when we have them sorted together.

3 REPLIES 3
Highlighted
New Contributor

Re: Using Email Domain to Sort by Organization

Hi JHB,

Your idea is cool.  We can see a few areas where this would be useful.  Thank you for submitting to us to consider.

- The GoToTraining Team
Highlighted
New Contributor

Re: Using Email Domain to Sort by Organization

I do this same thing for colleges. it woud be nice to be able to generate a pick list for org so that I don't have to find/edit all of the different abbreviations and spelling choices for the institution name - especially because some systems have the same domain, although they are technically different orgs.
Highlighted
Contributor

Re: Using Email Domain to Sort by Organization

Patty - Yeah, it's not perfect. But at least it helps.  For my face-to-face events (different system) I sometimes use a drop down - but then it has 172 organization names!  LOL.