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...
Here are few formulas-
=B1&C1&D1&E1&F1&G1&H1
=CONCATENATE(B1,C1,D1,E1,F1,G1,H1)
=CONCAT(B1:H1)
=BYROW(B.:.H,CONCAT)