Need to create a number from other columns

[Sierra Mike]

Not text as I earlier thought. I have columns C, D, E, F, and G. Total of
15 digits 5-2-4-1-3 respectively. In column A, I need to create a 15 digit
number that reads the other columns and prints them as one 15 digit number.
In other words, column C has '11001, column D has '15, column E has '6402,
Column F has '1, Column G has '102. Under format cells these are listed as
General number in each of these columns. I need in column A, the same format
to give me answer of '110011564021102. What formula can I put in column A to
get this desired outcome? Thanks.

 

[Don Guillett]

=c1&d1&e1 etc

 

[Mc/]

=c1&D1&E1&F1&G1

The &-sign serves as a concatenation marker.
This will work as long as each column has the correct number of digits.
If digits are truncated by zero suppression, you will have a problem.
One way to ensure the correct number of digits in each column would be to
use Data Validation to control manual data entry.
Column formatting to eliminate leading zero suppression would also help.

 

[Ron Coderre]

In case some of the values have leading zeros...

Try this:
=TEXT(SUMPRODUCT(C1:G1*10^{10,8,4,3,0}),"000000000000000")


Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)