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

.