<div>
<p>file<a class="fr-file" href="https://filedb.experts-exchange.com/incoming/2023/06_w23/1619628/zconcantete.xlsx" rel="ugc">zconcantete.xlsx</a></p>
</div>


zconcantete.xlsx

<div>
<pre><code class="code-1 nolinks" id="code-20-43540633-1">="("""&amp;TEXTJOIN(""" OR """,,B1:B30) &amp; """)"</code></pre><p>The preceding formula requires Excel 2019 or later, including Microsoft 365. If you have an earlier version of Excel, you will need VBA code.</p>
</div>


<div>
Perhaps the most straightforward formulas:<br />
<br />
F2: =A1&amp;B1&amp;C1&amp;D1&amp;E1<br />
F3, copied down: &nbsp;=F1&amp;A2&amp;B2&amp;C2&amp;D2&amp;E2<br />
<br />
If you have the TEXTJOIN function available:<br />
<br />
F2: =TEXTJOIN(&quot;&quot;, FALSE, A1:E1)<br />
F3, copied down: &nbsp;=F1&amp;=TEXTJOIN(&quot;&quot;, FALSE, A2:E2)
</div>


finnstone

zconcantete.xlsm

<div>
<div class="content wysiwyg-content fr-view">
<p>need someone to concatenate the rows for me</p><p>looking for formula that connects</p><p><br></p><p>A1,B1,C1,A2,B2,C2, ..etc to the end</p>
</div>
</div>



need someone to concatenate the rows for me
looking for formula that connects
A1,B1,C1,A2,B2,C2, ..etc to the end


=&quot;(&quot;&quot;&quot;&amp;TEXTJOIN(&quot;&quot;&quot; OR &quot;&quot;&quot;,,B1:B30) &amp; &quot;&quot;&quot;)&quot;
The preceding formula requires Excel 2019 or later, including Microsoft 365. If you have an earlier version of Excel, you will need VBA code.

Perhaps the most straightforward formulas:

F2: =A1&amp;B1&amp;C1&amp;D1&amp;E1
F3, copied down:  =F1&amp;A2&amp;B2&amp;C2&amp;D2&amp;E2

If you have the TEXTJOIN function available:

F2: =TEXTJOIN(&quot;&quot;, FALSE, A1:E1)
F3, copied down:  =F1&amp;=TEXTJOIN(&quot;&quot;, FALSE, A2:E2)

easy concatenate

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.