Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to create a text number from other columns | Excel Discussion (Misc queries) | |||
Create four columns out of one | Excel Discussion (Misc queries) | |||
Create stacked columns chart but with 2 columns for each x axis? | Charts and Charting in Excel | |||
Trying to create a page with three columns | Excel Discussion (Misc queries) | |||
How to create a chart with two X value columns | Charts and Charting in Excel |