Forum Discussion
merge cells
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 d...
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)