Formula to join cell values

[OfficeUser]

I have a formula as such: =A2&"-"&B2&"-"&C2

A2 = 21552
B2 = CH
C2 = 007 (Custom Formatted: 000)

The formula output is 21552-CH-7, instead of the expected result of 21552-CH-007. Is there a better way to manage this? Thanks!

 

[RoryA]

You can use the TEXT function:

=A2&"-"&B2&"-"&TEXT(C2,"000")

 

[OfficeUser]

Works great, thank you!!

 

[sreevignesh]

Dim c2 as long

 

[RoryA]

@sreevignesh

How would that help, or even work, with a formula?

 

[sreevignesh]

ʅ_(ツ)_ʃ
__ |
__ |
__/ \_