Bulk Enrollment for Moodle

This shows how to setup a spreadsheet (Excel, Numbers, GSheet,etc) for bulk enrollment. In addition here is the formula for automating email addresses from username:

Formula to split firstname and last name from one cell to two cells:

Insert in cell B2

=LEFT(A2,FIND(" ",A2)-1)

Insert in cell B3

=RIGHT(A2,LEN(A2)-FIND(" ",A2))