Creating a string list of cell entry - Values from excel sheet into one string w seperator

Hello,

I have Excel Sheet with surnames. It looks like

Name1
Name2
Name3

I need to search for these names in an search engine with the OR operator. What I want excel to do now is to return a string like

Name1 OR Name 2 OR Name3

where I define what the seperator (e.g. OR) should be. How can I do that? Since I have multiple hundred names in the sheet I dont wanna create the list by name.

Thank you very much in advance.

Regards

Tackleberry

Copy the formula in B2 down for as many names as you have in column A. The last row in column B will contain a string with all the names joined with "or". (You'll have to manually trim the last "or" from the string.)

Column A Column B
Name 1 =A1
Name 2 =B1&" or "&A2
Name 3 =B2&" or "&A3
Name 4 =B3&" or "&A4
Name 5 =B4&" or "&A5
Name 6 =B5&" or "&A6
Name 7 =B6&" or "&A7
Name 8 =B7&" or "&A8
Name 9 =B8&" or "&A9
Name 10 =B9&" or "&A10