P
Petee
I have 3 columns of numbers. The first column is always 1 number. The next 2
columns are either 2,3 or 4 numbers. I need to combine the 3 columns into 1 9
digit number. The problem I have having is some of these cells start with a
zero (0224). When I try to concatenate them, it strips off the preceding 0. I
need the zero to remain to look like column D.
Example:
A B C D
1 1423 8877 = 114238877
1 0012 0234 = 100120234
columns are either 2,3 or 4 numbers. I need to combine the 3 columns into 1 9
digit number. The problem I have having is some of these cells start with a
zero (0224). When I try to concatenate them, it strips off the preceding 0. I
need the zero to remain to look like column D.
Example:
A B C D
1 1423 8877 = 114238877
1 0012 0234 = 100120234