Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to Concatenate three cells. I want the end result to read in all numbers as the two following ways.

  1. #####-000-####
  2. #####-###-000

When I try to concatenate I am losing 2 zeroes. Anyone know how to fix this?

share|improve this question
did #soandos not answer your question? You might mark it as such unless you still need something further – datatoo Jul 13 '12 at 11:53

Given that the the numbers that you want to concatentate are in A1 and B1, the following two formulas will do what you are looking for:


share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.