| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combine two numbers -- not add
I want to take the numbers from two columns and combine - but them. For
instance: Column A = 01 Column B = 101 Column C will equal 01101 What function will i use to achieve this? Thank you, Kevin -- Is it the times or the Zeitgiest? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combine two numbers -- not add
=A1&A2
Regards, Alan. "KevinS" wrote in message ... I want to take the numbers from two columns and combine - but them. For instance: Column A = 01 Column B = 101 Column C will equal 01101 What function will i use to achieve this? Thank you, Kevin -- Is it the times or the Zeitgiest? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combine two numbers -- not add
Have you tried =A1&B1 ?
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "KevinS" wrote in message ... I want to take the numbers from two columns and combine - but them. For instance: Column A = 01 Column B = 101 Column C will equal 01101 What function will i use to achieve this? Thank you, Kevin -- Is it the times or the Zeitgiest? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combine two numbers -- not add
And maybe...
=text(a1,"00")&text(b1,"000") if those are really numbers. KevinS wrote: I want to take the numbers from two columns and combine - but them. For instance: Column A = 01 Column B = 101 Column C will equal 01101 What function will i use to achieve this? Thank you, Kevin -- Is it the times or the Zeitgiest? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combine two numbers -- not add
Thank you. That is exactly what I wanted.
-- Is it the times or the Zeitgiest? "Alan" wrote: =A1&A2 Regards, Alan. "KevinS" wrote in message ... I want to take the numbers from two columns and combine - but them. For instance: Column A = 01 Column B = 101 Column C will equal 01101 What function will i use to achieve this? Thank you, Kevin -- Is it the times or the Zeitgiest? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combine two numbers -- not add
Thank you. That is exactly what I wanted.
-- Is it the times or the Zeitgiest? "Bernard Liengme" wrote: Have you tried =A1&B1 ? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "KevinS" wrote in message ... I want to take the numbers from two columns and combine - but them. For instance: Column A = 01 Column B = 101 Column C will equal 01101 What function will i use to achieve this? Thank you, Kevin -- Is it the times or the Zeitgiest? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to get excel to combine numbers to a given total | Excel Discussion (Misc queries) | |||
| How to Combine two cells (numbers) but not add | Excel Discussion (Misc queries) | |||
| Using If to combine answers including text and numbers | Excel Worksheet Functions | |||
| Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
| how to combine numbers with the comma | Excel Worksheet Functions | |||
Linear Mode
