Extracting Custom Pattern Consisting of Numbers & Text From Alphanumeric String

[snb]

@Rick

You might have misinterpreted my suggestion: it's a UDF; so the result will be the 'filtered' value of another cell: no concatenation, no comma separation etc.

Because I have no idea what the other items look like I can only suggest something for the items provided:

Function snb_002(c00)
    snb_002 = Join(Filter(Split(Join(Filter(Split(Replace(c00, "USA", ".USA"), "."), "0"), "")), "0"))
End Function