Forum Discussion
Snippe3120
Nov 25, 2025Occasional Reader
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...
OliverScheurich
Nov 25, 2025Gold Contributor
Does this work in your sheet as well? I've applied this formula in Excel 2013.
=B2&C2&D2&E2&F2&G2&H2