[Solved]-Use Text Columns Wizard Separate Name Column Table First Name Last Name Columns Would Happ Q37161028

If you use the Text to Columns wizard to separate the NameColumn in the table below into First Name and Last name columns,what would happen if you separated the names at the space betweenfirst name and last name without making any other changes to thetable?

Select one:

a. Excel would return an error message.

b. Excel would add a new column to accommodate last names.

c. The two new columns would be created in a new worksheet.

d. The new last name column would overwrite the data in thestreet address column.

Expert Answer

---

Answer to If you use the Text to Columns wizard to separate the Name Column in the table below into First Name and Last name colum… . . .