Forum Discussion
Solved
Convert column of numbers into single line separated by 'OR'
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! 🙂
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.
2 Replies
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.
