2

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?

  • 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

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")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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