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

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?
 
J

Jacob Skaria

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Find Specific Text in a Text String 2
Find text based on multiple criteria 0
Count number times text appears in string 1
Searching and counting text in a spreadsheet 3
find a variable text string 2
Saving text with commas in a .csv file then converting to a .txt f 3
count no. of commas (,) in a string in a cell 3
Data, Text to Columns, has commas in the text, plus as a delimeter 2

Top