# Answer check: Google Sheets Split Text to Columns: Separate Name and Email

A2:A4 split into name and email columns: Avery Stone/avery@example.com, Blair Reed/blair@example.com, Casey Chen/casey@example.com. The separator is a comma.

The practice data is fictional. Reconcile each row before applying the method to a real file.