Function to join values in individual cells with other prefixed words

[krwlng]

Hi guys

need help here.
might be simple for the experts.

i have a single column of numbers.
A1, A1, A3, A4, A5

I would like to join these numbers in a format that would display the numbers such as

"NUMBER" = "A1" OR "NUMBER" = "A2" OR "NUMBER" = "A3" OR "NUMBER" = "A4" OR "NUMBER" = "A5"

The words "NUMBER" = and OR are the prefixed words.
Is there a way to do this?

[Crooza]

Please Login or Register  to view this content.

in the order you want of course

or

Please Login or Register  to view this content.

[krwlng]

i'm lost.
sorry. i am really new at this.
i've provided a sample below.
Column A has a series of numbers from J1 up to J300.
I need to somehow put this numbers in a formulae which will give me this exact output.
'Incident ID*+' = "J1" OR 'Incident ID*+' = "J2" OR 'Incident ID*+' = "J3"
if use the method above, i would have to enter the J1,J2,J3,J4 manually.

J1
J2
J3
J4
J5
J6
J7
J8
J9
J10
J11
J12

[boopathiraja]

Try

="incident Id*+ = " &A2 & " or"

[Crooza]

Post your worksheet with the data and an example inteh first cell of what you want the output to be