Hi,

Can you supply some example data and the result you expect. As much detail and info as possible 🙂

Thanks

Phil

Sorry,  here is the file.

Hi,

Can you provide the context for this, it might make it easier to work out a solution.  Why are you trying to do this?

In your examples, you state that you want the letters to the right of the letter in Col Q, but to exclude the letters in Cols R and S.

In your first example the only letters to the right of A, is G, but your expected result is GCBFE.

In the 2nd example, the letters to the right F are EJDG but your expected result is EJDGC.

In the 3rd example there are no letters to the right of G but your expected result is ACDEJ

So I'm not understanding your requirements as the result you state you want does not match up with the expected results you provide.

Regards

Phil

Hi Melinda

Perhaps something like this?

What I am doing is :

1) Join the range 2 times using CONCATENATE(). This will allow me to "loop" back to repeat the extraction.

2) Remove the unwanted texts from the concatenated string using SUBSTITUTE()

3) Find the position of the required letter

4) Extract the words from the concatenated string using MID().

Hope this helps

Sunny

Sunny

Thanks for coming through.  I really do appreciate the explanation! Thank you so very much.

Happy New Year