Forum Discussion
Exclude Certain text from a cell.
In the below image, I know the values which are A, B, C, ...H but I wont be having the values for 1 2 3 .. n
How can i capture the random values out of the fixed in a cell?
NOTE: All the variable is a "text" and the order of A, B, 1 doesn't remain the same.
Any function to capture the random value will help
1 Reply
That could be
=SORT(FILTER( FILTERXML("<r><n>" & SUBSTITUTE(TEXTJOIN(",",,A:A),",","</n><n>") & "</n></r>", "//n"), ISTEXT(FILTERXML("<r><n>" & SUBSTITUTE(TEXTJOIN(",",,A:A),",","</n><n>") & "</n></r>", "//n")) ))for
