Convert column of numbers into single line separated by 'OR'

[Dan_Scott]

I have a column of SKUs I want to convert into a single line of text, with each number separated by the word 'OR'. Example below. I'm at the bottom of the food chain of excel users, but I figure this is achievable with a fairly simple formula - can some whiz please help? Many thanks! :)

[#2 · Accepted solution]

@Dan_Scott 

Do you have Excel in Office 2019 or Microsoft 365? If so, you can use TEXTJOIN:

=TEXTJOIN(" OR ", TRUE, A1:A3)

Replace A1:A3 with the relevant range.

[#3]

Apart from the guy who made me coffee this morning, you are officially my favourite person today. Thankyou Hans! Have a good one, wherever you are.