62. Splitting text into columns (Text to Columns)

Splitting Text into Columns (Text to Columns)

**Text to Columns** in Excel is a powerful tool for splitting text into separate columns based on a delimiter or fixed width. For example, you can split full names into first and last names or separate values in a comma-separated list.

Steps to Use Text to Columns

  • Step 1: Select the column containing the text you want to split.
  • Step 2: Go to the Data tab and click Text to Columns.
  • Step 3: Choose the splitting method: Delimited (based on a character like a comma or space) or Fixed Width.
  • Step 4: Configure the delimiter or column breaks and click Finish to split the text.

Interactive Example: Split Text into Columns

# Full Name First Name Last Name
1 John Doe -- --
2 Jane Smith -- --
3 Alice Johnson -- --

Click "Split Text" to separate the full names into first and last names using a space delimiter.

Comments