•1 min read•from 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?
[link] [comments]
Want to read more?
Check out the full article on the original site
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