•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I produce a TEXTSPLIT such as in the bottom case in the picture?
Hello, I have only cursory knowledge on Excel/Calc logic. I have a variable cell containing a string containing elements separated by hyphens, which I intend to spill across columns, but it stops working properly (Case 3) when there is only one element since there are no hyphens.
I tried going around it by adding double hyphens to trigger the TEXTSPLIT, but an empty cell is created.
How can I make so that the result returns #N/A errors on unused "slots?" Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#rows.com
#TEXTSPLIT
#Excel
#Calc
#variable cell
#string
#elements
#hyphens
#columns
#spill
#Case 3
#double hyphens
#empty cell
##N/A errors
#unused slots
#trigger
#cursory knowledge
#result