SOLVED

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!

 

Dan_Scott_1-1627900474994.png

 

 

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

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.