Hi all,

I have a formula that I need creating and I would greatly appreciate some help.

I have two columns with the following data (this is a simplistic version):

abu dhabi transfers abu dhabi
transfers tirana tirana
transfers to vienna vienna
transfers mandraki mandraki
kos transfers kos
kos port transfer kos port


What I need is a formula that Puts a + sign immediately before the words in A1 that are in B1 (for example). So what I end up with is:

+abu +dhabi transfers abu dhabi
transfers +tirana tirana
transfers to +vienna vienna
transfers +mandraki mandraki
+kos transfers kos
+kos +port transfer kos port

I would really appreciate some help and thanks and rep will be added.

Thanks,

Ryan.