Excel Practice

TEXTSPLIT practice

Delimiters can turn an incoming text record into columns, rows or a rectangular table.

Lesson 92 of 92 · 3 exercises

Practise TEXTSPLIT

What you will practise

A column delimiter moves each text field into the next column. Numeric-looking text remains text.

TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])

The syntax above is a guide. Read the data and each task to choose the right arguments for your formula.

Original formula and spill examples

These examples use the original practice data. Fresh data changes the source; follow the current task. Enter one formula at the anchor. The workbook derives the entire spill without overwriting the source.

Exercise 1 · anchor D2

Original source cells
A1
Incoming record
A2
Mira,Studio,14
=TEXTSPLIT(A2,",")

Expected spill D2:F2 · 1 row × 3 columns. Numeric-looking TEXTSPLIT fields remain text.

Expected cells in D2:F2 · row order
MiraStudio14

Exercise 2 · anchor D2

Original source cells
A1
Incoming record
A2
Mira,Studio,14
E2
Keep source intact
=TEXTSPLIT(A2,,",")

Expected spill D2:D4 · 3 rows × 1 column. Numeric-looking TEXTSPLIT fields remain text.

Expected cells in D2:D4 · row order
Mira
Studio
14

Exercise 3 · anchor D2

Original source cells
A1
Incoming records
A2
JunXFieldX8;OnaXX15;PiaXRemote
=TEXTSPLIT(A2,"x",";",TRUE,1,"—")

Expected spill D2:F4 · 3 rows × 3 columns. Numeric-looking TEXTSPLIT fields remain text.

Expected cells in D2:F4 · row order
JunField8
Ona15—
PiaRemote—

3 exercises in this lesson

  1. Exercise 1 · answer in D2

    In D2, use TEXTSPLIT to split the comma-separated record in A2 into three columns.

  2. Exercise 2 · answer in D2

    In D2, use TEXTSPLIT to split A2 down one column using the comma as the row delimiter. Omit the column delimiter. Keep the note in E2 intact.

  3. Exercise 3 · answer in D2

    In D2, split A2 into columns at "x" and rows at ";". Ignore empty fields, match delimiters case-insensitively, and pad missing fields with "—".

Before you check your answer

  • Write one anchor formula. Enter the formula in D2. Every derived spill cell is read-only and points back to that same editor. Keep the source intact.
  • Check the whole shape. Inspect every row and column of the result, including repeated records, order, text casing and padding. A matching first cell alone is not enough.
  • Recover a blocked spill. A #SPILL! error identifies an occupied cell or the worksheet edge. Correct the formula to fit the requested shape; keep immutable source notes. View source and View spill help you inspect both areas.

How the answer is checked

The workbook checks every row and column, the complete dimensions, each typed value and the spill placement. It requires the taught function to execute and tests reusable formulas against changed trusted source data. Fixed results, a function in an unused branch, edited source or submitted derived cells cannot earn completion. Equivalent reusable formulas can pass. Account progress is saved only after the server verifies the same task and access rules.

Use progressive hints when you need help, then try the task again with fresh data. Correctly solving a step opens the next exercise.