Jada has a worksheet listing the first and last names of her students in a single column.Which Excel tool can she use to split the names into separate columns?
A) Convert Text to Columns Wizard
B) Import Text Wizard
C) Get & Transform
D) Transform paste option

Question

Quizplus · Accepted Answer

The Convert Text to Column Wizard allows the user to split data in a single column into multiple columns based on a delimiter, such as a space between a first and last name.

Jada Has a Worksheet Listing the First and Last Names