grallaria-excelsa
1 post
a place for me to store fun/useful excel tips for my own reference
Don't wanna be here? Send us removal request.
Statistics
We looked inside some of the posts by grallaria-excelsa and here's what we found interesting.
Average Info
Notes Per Post
0
Likes Per Post
0
Reblog Per Post
0
Reply Per Post
0
Number of Posts By Type
Text
1
Last Seen Tumblr Blogs
Fun Fact
After the announcement of the deal with Yahoo!, there were 170K signatures of unhappy Tumblr users petitioning to prevent the sale in 2013.
Text
Split a delimited list into two columns
Functions used: TEXTSPLIT, TEXTJOIN
Formula: =TEXTSPLIT(TEXTJOIN("~", TRUE, list), "/", "~")
Context: you have a delimted list which you want to split into two columns.
If you go row by row you can do it using TEXTSPLIT on its own, but if you want the result in a single array this won't work. Instead, you can use TEXTJOIN to combine the values into a single string, then use TEXTSPLIT on that.
Step-by-step
Evaluating TEXTJOIN with [delimiter] "~" results in this:
(Setting [ignore_empty] to TRUE will skip any empty rows in the list. Not relevant here but a useful feature).
Then applying TEXTSPLIT with [col_delimiter] "/" and [row_delimiter] "~" gives the desired result:
0 notes