TEXTSPLIT Function

Published by

on •1 min read

The TEXTSPLIT function splits a text string with a given delimiter into multiple values. The output from TEXTSPLIT is an array that will spill into multiple cells in the workbook.

Excel 2024 Dynamic array by Dave Bruns · Updated 18 Jun 2025 Related functions Purpose Split a text string with a delimiter Purpose Return value An array of split values Return value Syntax Using the TEXTSPLIT function Functions

Learn more