repeat take out a string

[harisonford]

5,,,,y this is among other data in one cell

i want the system to get it for me by saying i want 5 to y and what is in between regardless of the number of the charcaters in between

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=578360

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).