View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dante Huapaya Dante Huapaya is offline
external usenet poster
 
Posts: 10
Default Extract specific string

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