Excel combine all cells if they contain specific Text

[dshafique]

Hi everyone, I have been troubled with this task in Excel. I have a cell with unstructured IDs. They are not seperated by a delimiter, or space, and I need to pick out every instance of G-ROBOTXXXXX (G-Robot followed by 5 characters)
example:

S-1-5-21-1451601339-2568154591-3116655374-200646G-ROBOTGP004S-098568675G-ROBOTP00988

The cells vary in length, and are all over the place. Some cells have 2 instances of G-ROBOTXXXXX, some have 5, some have none. I want to be able to pull out all the instances and keep them in seperate cells if possible. I can do this manually, but there are hundreds of rows and will take me days.

I would appreciate any help or direction from you guys.

thanks in advance!

 

[Fluff]

How about
=IFERROR(MID(SUBSTITUTE($A2,"G-ROBOT","|#|G-ROBOT",COLUMN(A1)),FIND("|#|",SUBSTITUTE($A2,"G-ROBOT","|#|G-ROBOT",COLUMN(A1)))+3,12),"")
Filled down & across
Change the |#| if need to something that will never be found in the data