Find the same text multiple times in a string seperated by commas

  • Thread starter Thread starter clcnewtoaccess
  • Start date Start date
C

clcnewtoaccess

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,0251024,0642510,0280347,3526440,0251024,0280346,0280501,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?
 
=FIND(SearchString,MasterString,StartingPosition)
The third parameter is the starting position.
You give 1 to return the 1st instance ie 17
You give 18 to return the 2nd instance
 
Back
Top