Using wildcards with UDF that uses Replace

[Einarr]

Hello, my first post so I hope I am doing this correctly

I have the Function below that finds the nth occurrence of a substring in a string and it works great, but I will not take wildcards

And I desperately need to use it with wildcards

Can anyone see how to alter the function or the way I am using it that will permit me to use it using wildcards?

I have tried but have been no luck

Thanks for considering my question

Function

Please Login or Register  to view this content.

How I am calling it

Please Login or Register  to view this content.

[kev_]

Welcome to the forum
Something happened when you pasted your function - it is not complete
Please find the rest of it, test it, and then replace the VBA above with complete, working function - thanks

should be on 2 lines:

Please Login or Register  to view this content.

[I]
where is the start of this loop ?

Please Login or Register  to view this content.

[Einarr]

Hello kev_, sorry about, I updated the function

[davsth]

what does replacing wildcards mean

if the cell was abcdefeghijkabcdefeghijk and you wanted to replace the 2nd def* with xyz what is the answer?

[Einarr]

Here is a common example of what I want to do, I have a column of data that looks like this

What types of activities have you engaged in with [Field-3]? You can choose multiple answers. - What types of activities have you engaged in with [Field-3]? You can choose multiple answers. - Selected Choice
What types of activities have you engaged in with [Field-4]? You can choose multiple answers. - What types of activities have you engaged in with [Field-4]? You can choose multiple answers. - Selected Choice
What types of activities have you engaged in with [Field-5]? You can choose multiple answers. - What types of activities have you engaged in with [Field-5]? You can choose multiple answers. - Selected Choice
etc.

I want it to become this:
What types of activities have you engaged in with [Field-3]
What types of activities have you engaged in with [Field-4]
What types of activities have you engaged in with [Field-5]
etc.

So I need to remove this:
? You can choose multiple answers. - What types of activities have you engaged in with[*]? You can choose multiple answers. - Selected Choice