Title: If you use the Text to Columns wizard to separate the Name Column in the table below into First Name ... Post by: David_DiSanto on Nov 17, 2017 If you use the Text to Columns wizard to separate the Name Column in the table below into First Name and Last name columns, what would happen if you separated the names at the space between first name and last name without making any other changes to the table?
A B C 1 Name Street Address City 2 Mary Smith 123 Elm St Greensboro A) Excel would add a new column to accommodate last names. B) The two new columns would be created in a new worksheet. C) Excel would return an error message. D) The new last name column would overwrite the data in the street address column. Title: Re: If you use the Text to Columns wizard to separate the Name Column in the table below into First ... Post by: mastema on Nov 17, 2017 D
|