Forum Discussion
What delimiter shall I use?
That's as Patrick2788 suggested, or if you prefer with formula, practically the same could be
=TRIM( TEXTSPLIT(SUBSTITUTE( <line>, "), (", "),:(" ), ",:") )Above for single row, how to split texts in 2D you may find patterns, few of them. But again, that will be spill, not table.
PeterBartholomew1 , not to care about digits that could be
=REGEXEXTRACT( @data, "(?xim) \( (?>[^()] | (?R) )* \)", 1)or
=REGEXEXTRACT( @data, "(?xim) \( (?:[^()] | (?R) )*\)",1 )but we have spills as result, not structured table.
Thanks SergeiBaklan , any other solution for guys like me :( where in our Excel, REGEX is not available.
Br,
Anupam
That's as Patrick2788 suggested, or if you prefer with formula, practically the same could be
=TRIM( TEXTSPLIT(SUBSTITUTE( <line>, "), (", "),:(" ), ",:") )Above for single row, how to split texts in 2D you may find patterns, few of them. But again, that will be spill, not table.
Thanks a lot SergeiBaklan , last question on this topic :), can you please also share a formula to count the number of columns with non-zero elements like below, in column "AI":-
That could be like
=COUNTIFS( C2:AH2, "<>(0, 0)" )