I think it would be helpful to us if your provide a little more detail about
the structure of the text. Will the parts you are interested in **always**
be separated by underline characters? If so, will there always be two of
them before the first string you wish to extract? Also, if so, will there
**always** be 5 underline characters (that is, 6 delimited pieces of text)?
Will there ever be any numbers in the text before the first string you wish
to extract? Are the three strings you wish to extract **always** grouped
together (one following the other) as your example shows?

--
Rick (MVP - Excel)



"Homecomingwarrior" wrote in
message ...
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