Excel: How to Separate First Names and Surnames Using Text to Columns

The video tutorial addresses how to separate first names and surnames in Excel when they are combined in a single column with numbers. It introduces the 'Text to Columns' feature in Excel, which allows users to split data based on delimiters like spaces. The tutorial guides through selecting the appropriate delimiter, previewing the data separation, and finalizing the process to organize names into separate columns, removing unwanted numbers.

What is the main issue with the data as described in the first section?

• The names are combined with numbers and not separated.

• The names are already separated into different columns.

• The names are in alphabetical order.

• The names are missing entirely.

Which Excel feature is used to separate data into different columns?

• Data Validation

• Text to Columns

• Pivot Table

• Conditional Formatting

What option should be selected to separate data based on spaces?

• General

• Text

• Delimited

• Fixed Width

What character is used as a delimiter in this example?

• Comma

• Tab

• Semicolon

• Space

What happens to the numbers in the first column after using 'Text to Columns'?

• They remain in the first column.

• They are combined with the surnames.

• They are deleted.

• They are moved to a new sheet.