View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
clcnewtoaccess clcnewtoaccess is offline
external usenet poster
 
Posts: 22
Default Find the same text multiple times in a string seperated by commas

I can do a find on my text string and it returns the number of the first
character of the text, my problem is when it shows up multiple times in the
same string how do I extract the number for each repetition.
Example:
0573300,0573300,0251024,0257013,0257025,0257070,02 51024,0642510,0280347,3526440,0251024,0280346,0280 501,0512520,MCP
You can wee that 0251024 shows up 3 different times so I get 17 when I do a
find. The question is, how do I get the other 2 to show up?
--
clcnewtoaccess