362202 Seperate data in field

Hello. I have an excel spreadsheet with 3100 records. in one column, we have a first name, last name, zip code and yes/no that look like this: Cliff Gillespie 61704 Yes Tamika Jones 44310 No We need for you to seperate each item into it's own field. So you will turn this one field into 4 fields: First Name Last Name zip code yes/no