Unfortunately, you didn't answer all the questions I asked, so I am still
not sure how to reply to you. Are the items you showed in your list in a
column, one item per row? Where do you want the extracted strings to go...
an array inside of
VB code, another column or somewhere else?
--
Rick (MVP - Excel)
"Dante Huapaya" wrote in message
...
The string start always with "S" and finished with 8 digits and a VB
function
will be help me so much.
Thanks
Dante
"Rick Rothstein" wrote:
I think you may have to tell us more about what you are trying to do and
what you have to work with. First, I'm assuming each item in the list you
showed is on a separate row. Do the strings you are trying to extract
always
start with a single letter? If yes, I'm guessing it is not always an "S",
is
it? Again, if so, then will only digits follow it? In other words, are
you
looking for a single letter followed by eight digits? After you answer
the
above questions, here is the most important question... where did you
want
these values "extracted" to? An array in VB code? Another column?
Somewhere
else?
--
Rick (MVP - Excel)
"Dante Huapaya" wrote in message
...
Hi all,
I need extract a specific string and my cells may contains many
alphanumeric
data
In this example I need Extract only S00059997 and S00075671 the LEN is
9
all
the time.
Thanks for your Help
Data_Account
----------------
ANY-NOTES
ANY---NAMES
S00059997
ANY-NOTES
S00075671
Dante
.