joukiejouk
asked on
Need help copying data from Excel and separating the data in a .CSV by commas (see screenshot for example)
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
Excel list
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, 1234@sample.com, 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.
Excel list
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, 1234@sample.com, 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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.