| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 07 - combining number
I have numbers that represent code/state and would like to combine them in
one cell (Column B) where the "xxxx". Example: A B C Atlanta 00100 3000 xxxx 4930 3001 xxxx 5690 Results - I looking for 1 A B C 2 Atlanta 3 00100 4 3000 300000100 4930 5 3001 300100100 5690 Column A4:A5 = code Column $C$3 = state Column B = formula to combine the two (code_state) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining text and cell reference keeping number format | Excel Discussion (Misc queries) | |||
| Combining worksheets with common column but different number of ro | Excel Worksheet Functions | |||
| the "0" number is lost when combining multiple columns | Excel Worksheet Functions | |||
| combining text & number from different cells | Excel Discussion (Misc queries) | |||
| Combining workshhets with different number of colums and column wi | Excel Discussion (Misc queries) | |||
Threaded Mode
