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

New Contributor

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 Replies
best response confirmed by Dan_Scott (New Contributor)


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




Replace A1:A3 with the relevant range.

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.