If col A contains a b c d e f, I want a separate link to be opened for each value. E.g If the user click on "a", it should open link1, "b" should open link2.
This question is asked often here on Answers. Check out these previous posts for possible solutions:
I hope these are helpful for ya.