when you want to separate a list of full names into last and first names.
1) Select the range with full names.

2. On the Data tab, click Text to Columns.

The following dialog box appears.
3. Choose Delimited and click Next.

4. Clear all the check boxes under Delimiters except for the Comma and Space check box.
5. Click Finish.

You get a live preview of how your data will be separated.

No comments:
Post a Comment