Challenges in Concatenate formula

[sshrikanth2]

Hi,

I need your help...

I have a three columns in a workbook which is mentioned as below. The Customer ID should be equal to 9 digits so to make the Tax ID equal to 9 digits i did – Select cells > Right Click > Format Cells > Custom > Under Type, add zero 9 times “ 000000000 ” > Ok. When i applied CONCATENATE formula the zeros are not appearing but i want zeros to appear in the outcome. I appreciate your help.


A B C

Customer Name Customer ID Formula Outcome

Vijay India Ltd 004598633 =CONCATENATE(A2,";",B2) Vijay India Ltd;4598633
Sallu Bhai LLC 633546987 =CONCATENATE(A2,";",B2) Sallu Bhai LLC;633546987
Raju Bhai Cornwell 000001458 =CONCATENATE(A2,";",B2) Raju Bhai Cornwell;000001458



Regards,

Srikanth M

 

[Firefly2012]

Use TEXT formula instead:

=A2 & ";" & TEXT(B2,"000000000")

 

[VoG]

Try

=CONCATENATE(A2,";",TEXT(B2,"000000000"))