|Typically, the CONCATENATE function or Concatenation Operator & is used to join cells and text strings:|
=CONCATENATE(A1, "OR", A2, "OR" ,A3)
=A1 & "OR" & A2 &"OR" & A3
However, this would really be a pain to enter for 100 items.
Instead, I've written a User Defined Function (UDF) to perform the Concatenation for you.
1 - Open the VBA Editor via Alt-F11
2 - In a Standard Module, paste the code found below
3 - In any worksheet cell enter:
(Replace A1:C5 with the range of cells you want to concatenate)
Function myQuery(target As Range)
Dim myElement As Integer
Dim buildQuery As String
'Loop through range
For myElement = 1 To target.Cells.Count
'Concatenate cells, adding " OR " after each one
buildQuery = buildQuery & target.Cells(myElement) & " OR "
'Strip off last " OR " and return string
myQuery = Left(buildQuery, Len(buildQuery) - 4)