Skip to content

Stockertim Dictionary · Technology

Text to columns

Also called text to column, split column, column splitting

In short

A spreadsheet tool that splits the contents of one column into several, using a separator such as a comma or a fixed character width.

  • Beginner
  • Technology
  • Checked

In detail

Exported data often arrives with several fields packed into one column: a full name, an address line with commas, or a code such as LAG-2026-0143. Text to columns divides each entry into parts and writes them into neighbouring columns. In Excel it sits on the Data tab and runs as a short wizard.

The wizard offers two methods. Delimited splitting breaks the text at a chosen character such as a comma, a tab, a space or a hyphen, and can treat several separators in a row as one. Fixed-width splitting cuts at set character positions, which suits older system reports where every field occupies the same number of characters. A final step sets the format of each new column: General, Text or Date, with the order of day, month and year, and any column can be skipped.

That format step does much of the cleaning. Choosing Text keeps leading zeros on codes and phone numbers that General would remove. Choosing Date with the right order turns text dates into real dates. Running the tool on a column of numbers stored as text, with no separator, is also a quick way to convert them into numbers.

The tool writes over whatever is in the columns to its right, usually after a warning that is easy to click past, so space should be cleared first. It is also a one-off action: new rows are not split automatically. For data that refreshes, newer formula functions such as TEXTSPLIT, or an import query, repeat the split each time.

Worked example

A clinic in Kumasi exports patient visit codes in the form KMS-2026-0143 and needs the year on its own.

  1. Text to columns, delimited by the hyphen, writes KMS, 2026 and 0143 into three columns
  2. The third column is set to Text so 0143 keeps its leading zero

The year can now be filtered and counted, and the visit number is unchanged.

In practice

Office staff split names, addresses, account codes and exported report lines, and use the date-format step to repair dates that arrived as text in day-month-year order.

Watch out

  • It overwrites the columns to the right; insert empty columns first.
  • General format drops leading zeros from codes; choose Text for identifiers.

Learn it properly

Official sources

Facts last checked on 9 November 2026.

Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.

English