Combine numeric text and retaining leading zeroes

[tuneloon]

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.

[shg]

Row\Col	A	B	C	D	E
1	5	1	101	501101	D1: =A1 & TEXT(B1, "00") & TEXT(C1, "000")
2	5	10	102	510102
3	5	4	47	504047

[newdoverman]

Format the cells as text and the leading zeros will be retained. You can also lead the cell value with ' and the contents will be text.

	A	B	C	D
1	5	01	101	501101
2	5	10	101	510101
3	5	04	047	504047

Top row was formatted as text, the middle row was left as General, and the bottom row used ' for cells with leading 0.

[tuneloon]

much appreciated.

[shg]

You're welcome.