Question

assume that you have full name of the employee in one column of Ms Excel sheet. the option___ let you split the full name into column first name and last name​

Answer 1

Answer:

Select the column of full names that you'd like to separate. Head to the Data tab > Data Tools group and click Text to Columns. On the first step of the Convert Text to Columns Wizard, select the Delimited option and click Next. On the next step, select one or more delimiters and click Next