Blog

=TEXTSPLIT

by jbalboa

https://www.ablebits.com/office-addins-blog/textsplit-function-excel-split-cells-strings/

Excel TEXTSPLIT function

TEXTSPLIT availability

Basic TEXTSPLIT formula to split a cell in Excel

Split a cell horizontally across columns

Split a cell vertically across rows

Split text by substring

Split string into columns and rows at once

Separate cells by multiple delimiters

Split text ignoring empty values

Cell splitting case-sensitive or case-insensitive

Pad missing values in 2D array

Split dates into day, month and year

Split cells and remove certain characters

Split strings skipping certain values

TEXTSPLIT alternatives