Function To Return Common Words To 2 Cells

  • Hello friends,
    I'm trying to write UDF which getting RegEx pattern and a certain cell as arguments and returns only matching string.
    For examples for string "The quick brown fox jumps over the lazy dog", and RegEx pattern "\w{4}" the function will return two words "OVER" and "LAZY".
    What should I change in my code?


    Thank you.

  • Re: Function To Return Common Words To 2 Cells


    Hi all,
    i think I solved the thread of myself, the code is below:



    or



    Thanks

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!