Please see the attached Excel file. I need to concatenate some hundred cells like in the example. But using Concatenate or & will take lot of time. Is there any way possible without macro to do the job. Or, macro is the only solution.
I need to add names in B3, B4, B5, and so on. And the result should be Frank or Bill or Lucy... by adding an 'or' between the names.Concatenate-Names-Using-Or.xlsx