<div>
Can you please offer a VBA solution?<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
Is there a way to combine cell contents across a row to be merged into one? For example:<br />
<br />
A1: 2800<br />
B1: 2345<br />
C1:78598<br />
<br />
Usually, I would create a formula:<br />
<br />
&quot;A1&quot; &amp;&nbsp;&quot; &quot;&nbsp;&amp; &quot;B1&quot; &amp;&nbsp;&quot; &quot;&nbsp;&amp; &quot;C1&quot; to be merged into one cell that contains the formula:<br />
<br />
D1: 2800 2345 78598<br />
<br />
Please note the space between each cell content. The nuance is that the number of cells to be combined is variable.<br />
<br />
Thank you
</div>
</div>


Hi

Is there a way to combine cell contents across a row to be merged into one? For example:

A1: 2800
B1: 2345
C1:78598

Usually, I would create a formula:

"A1" & " " & "B1" & " " & "C1" to be merged into one cell that contains the formula:

D1: 2800 2345 78598

Please note the space between each cell content. The nuance is that the number of cells to be combined is variable.

Thank you

Excel - Formatting Concatenation of Cells

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