I have 3 columns of data that I need to combine, but I need to retain leading zeroes to make the end result correct. As an example

5 01 101
5 10 102
5 04 047

I need to have the values 501101, 510102 & 504047 returned and not 51101, 510102, 5447.

Could anyone help me with this. I was thinking a formula would be easiest, but I haven't been able to find anything to help me.