VFLE_VT_1CAAGK_790006_BH4A004M02_STALVTBAKAF


From this string I may need to extract 1CAAGK or 790006 or BH4A004M02

Not all rows of data are consistent in the wording however they will have a
6 digit alfa string starting with a 1; a 6 digit string starting with 7 or 8
and a 10 digit alfa/numeric with no specific beginning number or alfa.

Though about delimiting the entire worksheet but still would require manual
input ro remove unneeded data.

Currently someone plugs the number/digit that we are looking for.

please help.

just beginning...
Thanks !
-W