A data analyst at a nonprofit organization is working with a spreadsheet that contains member name data in column C. They want to divide this data so that first names are stored in one column and last names in another. Which tool should the analyst use?

Correct
To move the first and last names in column C to their own columns, a data analyst would use the SPLIT function.