As I learned here
=TEXT('Export 1'!A2,"00") & TEXT('Export 1'!B2,"0000") & TEXT('Export 1'!D2,"0000")
allowed me to combine three cells into one cell. The input is 01 1000 1234 output is 0110001234
The second set of number "1000" is going need to be changed to a 3 digit number. All of the numbers that are being converted have a "0" in the second position. I need a way to get rid of that zero and turn 1000 into 100 and number like 2024 to 224.
Bookmarks