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.
Bookmarks