merge cells

Question

I have a table with dozens of rows and seven columns. Each column (B through H) contains a two-digit number in txt format because I want to retain the leading zeros.I'm having trouble merging the different numbers from columns B through H into a separate cell (column A).The goal is to merge each individual row (columns B through H) into the same row in column A.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B&nbsp;&nbsp; C&nbsp;&nbsp; D&nbsp;&nbsp; E&nbsp;&nbsp;&nbsp; F&nbsp;&nbsp;&nbsp; G&nbsp;&nbsp;&nbsp; H12345678909854&nbsp;&nbsp; 12&nbsp; 34&nbsp; 56&nbsp; 78&nbsp; 90&nbsp; 98 &nbsp;5465432109870203&nbsp;&nbsp;&nbsp; 65 43 &nbsp;21&nbsp; 09 &nbsp;87 &nbsp;02&nbsp; 03…None of the formulas provided in Excel (Microsoft Office LTSC Professional Plus 2021) help.Do you have a solution?Thanks in advance.

oliverscheurich · Answer

Does this work in your sheet as well? I've applied this formula in Excel 2013.=B2&amp;C2&amp;D2&amp;E2&amp;F2&amp;G2&amp;H2&nbsp;

m_tarler · Answer

can you be more specific about what doesn't work and why?

as Oliver suggested a simple & between terms should work

but CONCATENATE() should work on older versions

On newer excel CONCAT() and TEXTJOIN() should work

but each of these solution will need to be done and then copied/filled down

if you are interested in an array function to do all rows at once you could use BYROW() helper function or interestingly the old CONCATENATE() might work because at least in the newer excel you can use this (until they fully obsolete it):

=CONCATENATE(B2:B3,C2:C3,D2:D3,E2:E3,F2:F3,G2:G3,H2:H3)

Forum Discussion

merge cells

2 Replies

Resources