Excel Job Test Question: How to Copy Formatting in Excel?

[@joeallen9643]

In your question which formula to use in separating first and last name, your response at 7:42 is the correct answer is Split to Column then later you inform that the correct answer is Text to Column. Thank you for your videos, just pointing out a problem.

[@OnlineTrainingforEveryone]

Thanks Joe. I must have misspoke - the correct answer is Text to Column, as "Split to Column" featured doesn't exist in Excel. Appreciate you for bringing it up!