Yes, xor's solution is much less resource hungry than mine, doesn't need array-entering and is shorter too, however be aware, that if there are multiple digit/letter combos in the same string next to each other that they must only be separated by a single space.
Replacing all of the 15 instances of A3 in xor's formula with TRIM(A3) seems to help in quick testing.
|