These instructions are for Excel on a PC. Icons and selections may vary if accessing via Excel on a Mac.
1. Open exported RSVP Report in Excel.
2. If shown, click Enable Editing.
3. The Excel file contains the RSVP responses with member names in column A.
4. Split the member names into two columns:
A. Select column B (to add new column next to the member list).
B. Click Home.
C. Go to Insert > select Insert Sheet Columns.
5. Select the cells with the Member names.
6. Select Data > click Text to Columns.
7. Choose Delimited > click Next.
8. Check box for Comma > click Finish.
9. Microsoft Excel pop-up appears, click OK.
10. The Member names have been split between last name and first name.
