For a group attendance list.  For Privacy reasons we can’t list of the attendees full-name, but their first name and last name initial was considered private enough.

The Excel function to do this was very simple, using the FIND and MID functions:

=MID(A2,1,(FIND(" ",A2)+1))

Related posts:

Getting a list of users in an Active Directory group. Getting a simple list of AD Group Members Getting a list of users in an AD Group. using Vbscript.

Powered by YARPP.