Forum Discussion

Copper Contributor

Sep 14, 2020

Concatenate VBA solution

Digit 1 Digit 2 Digit 3 Digit 4 Digit 5 Digit 6 Digit 7 Digit 8 C 1 1 1 1 0 1 1 C 1 1 2 2 0 2 2 C 1 1 3 3 ...

Diamond Contributor

Sep 14, 2020

As variant

=TEXTJOIN(".",1,A2:H2)