Comments on: TEXTSPLIT function in Excel: split cells / text strings by delimiter

There may be various situations when you want to split cells in Excel. Now, we finally have a special function for this, TEXTSPLIT, that can separate a string into multiple cells across columns or/and rows based on the parameters that you specify. Continue reading →

Comments page 2. Total comments: 44

  1. for those like me who yet have Textsplit available, how to split text into array?

    Thanks ahead!

    1. Hello Sunny,

      To split text into multiple columns, you can use older functions that work in all Excel versions. The formulas are slightly more complex, but they do work. For more details, please see the "TEXTSPLIT alternatives" section of this tutorial.

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)