You could select them all, and then "Save As" to a .RTF file. Then Open
the file. If you open the file in Excel, you will be able to "count" the
members.
I saved it and loaded it into Excel; however, I would like you to load it so
that it seperates it by name and another column for their email address. Any
suggestions on how to load it so it automatically formats that way?
In that case, do it this way. Start over with your list open.
Select them all, File, Save As, and pick "Text Only (*.txt)". Now Open
Excel, and then File, Open, files of type = Text Files, and pick your
file. In the text import wizard you want Delimited and you will pick
Tab. Just walk through to the finish.