Need to create a number from other columns
 

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.
--
Sierra Mike

Need to create a number from other columns
 

=c1&d1&e1 etc


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sierra Mike" wrote in message
...
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.
--
Sierra Mike

Need to create a number from other columns
 

=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.

Need to create a number from other columns
 

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

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


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

Regards,

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


"Sierra Mike" wrote in message
...
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.
--
Sierra Mike