•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