We needed a First-name & Initial list.

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.

Screenshot of excel spreadsheet showing Firstname and Initial

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

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