Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
2  
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

1 Answer 1

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:

=CONCATENATE(A1,"-000-",B1)
=CONCATENATE(A1,"-",B1,"-000")

share|improve this answer

Your Answer

 
discard

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.