combine two numbers -- not add

  • Thread starter Thread starter KevinS
  • Start date Start date
K

KevinS

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
 
Be advised that the result will be text, though, and you will not be able to perforn mathematical functions with it.
so if you want the result to be a value, try something like
=Value(A1&B1)
 
Dave Peterson said:
And maybe...

=text(a1,"00")&text(b1,"000")

if those are really numbers.
Click to expand...

Well, that appears superfluous to me, AFAIK.
I just ran a test sample, and values are concatenated just like strings by the "&" operator. So Text function is not really needed, whereas if you want to receive the result as a value, the Value function will be necessary.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 07 - combining number 2
Excel 07 - Combining Number minus the excess wording 1
Excel Concatenate with line breaks but ignore blank cells 3
How do I compare tow columns of numbers? 1
combining data from two columns into one 1
How to Combine two cells (numbers) but not add 7
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Combine two columns and delete original 1

Back
Top