| 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 |
| 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 | |||
Threaded Mode
