| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combine 2 columns of numbers (A+B=C)
This has me totally stumped......
Is it possible to combine column A with column B to get this result? Column A Column B Column C 8888021100013 00020 888802110001300020 9310004342206 00003 931000434220600003 I can combine the A&B ok but I keep losing the zeros in column B and my result looks like this: Column A Column B Column C 8888021100013 00020 888802110001320 9310004342206 00003 93100043422063 The string in column B must be 5 numbers and I have tried many differing formatting options but just cant seem to get the wanted result. Would really appreciate if someone could point me in the right direction. Regards, Dean |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combine two numbers -- not add | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| combine 2 columns | Excel Worksheet Functions | |||
| How to combine two columns? | Excel Worksheet Functions | |||
Threaded Mode
