Need to know how to grab all the data from the column FIRST NAME
and LAST NAME
in the Excel list and export them to a CSV seperate by commas
This CSV file is for the purpose of creating 300 user email account in Office 365. So, from the Excel list (screenshot above), I would need email, First Name, Last Name, and First and Last Name to be seperated by commas in the CSV file. For example, firstname.lastname@example.org, john, doe, John S Doe . Is this something I need to do in the CSV file? Some sort of setting? Those who have worked with Office 365 and need to create mass email accounts will likely know what I am talking about or have gone through this.