Exclude Certain text from a cell.

[paramdave]

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 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

[#2]

@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