multiple returns from find function

Hi there,

I have a find function I am using with the below macro. It pastes the result into the specified cell but I am wondering...if the search query has more than one result then how do I do this and then paste it into the destination cell?

I have pasted the code below which finds the first value it finds and pastes it into my destination cell.

Please Login or Register  to view this content.

I have also pasted the swap string function I am using just for reference:

Please Login or Register  to view this content.

I hoped there was an easy way to do this but I couldn't find one. If anyone knows then that would really help.

Thanks,
Jag

Hey there, I am looking to add them to the destination cell. So basically concatenate the value with the new value if another is found, example would be:

Please Login or Register  to view this content.

Jag