1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Previous function that textsplit replaced

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?

submitted by /u/SATprepdropout
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article