Forum Discussion

Copper Contributor

Jul 01, 2020

Exclude Certain text from a cell.

Formulas and Functions - 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 ...

Community.xlsx16 KB

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Jul 01, 2020

paramdave

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