Excel_prefixed with 0 and how to concatenate those columns in excel

Posted on


with the help of the above link i prefixed the 0 in excel.

Now i want to concatenate these columns A &B to C.

Please let me know how to do that.

column A      column B           column C
06789         00054              Expected: 0678900054
                                 Actual:   0678954


Remember that concatenating numbers is actually concatenating the underlying number (6789 and 54 in your example) not the formatted string.

You can do what you want using:


where “000000” is the formatter you applied.

Leave a Reply

Your email address will not be published. Required fields are marked *