•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Previous function that textsplit replaced
Our take
Before the introduction of the Textsplit function, users often relied on a combination of functions like `TEXTSPLIT`, `MID`, or `FIND` to extract text from a single cell into multiple columns based on unique delimiters. This approach required manually specifying each delimiter and crafting complex formulas, which could quickly become cumbersome. For example, a typical formula might look like `=MID(B2, FIND("[", B2), FIND("]", B2) - FIND("[", B2))`, making the process both time-consuming and prone to errors. Textsplit simplifies this task, enhancing
Before Textsplit, what function would we use to break out a cell into multiple columns that had unique delimiters?
I used to do it all the time, but for the life of me I can not remember what it was.
In the function we would have to type everything out like:
=?????(b2,{"[ ","] "," ",})
That is just an example.
Maybe it was not "splitting" as much as it was taking text from one cell and sourcing it into several columns.
Does this ring any bells?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#real-time data collaboration#real-time collaboration#Excel alternatives#Textsplit#function#multiple columns#cell#break out#unique delimiters#delimiters#excel#sourcing#example#type#taking text