| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find the same text multiple times in a string seperated by commas
=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 -- If this post helps click Yes --------------- Jacob Skaria "clcnewtoaccess" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count no. of commas (,) in a string in a cell | Excel Worksheet Functions | |||
| count no of times a letter occurs in a text string | Excel Discussion (Misc queries) | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| Splitting data in a single cell that is seperated by commas, then moving to make individual rows | Excel Discussion (Misc queries) | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
Hybrid Mode
