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

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