Hi,

I used this (link below) to help me combine cells into a single cell in Excel 2010 which worked dead on

http://office.microsoft.com/en-001/e...010248390.aspx

Combined these (spaces show cell separators)
430877 - I 3 2 02 TR 05 - AC 01 - 2 30

to >> 430877-I322TR5-AC1-230

the problem is that I had to custom format the cells shown with '02' and '01' but when the cells are combined the first zero is lost.

Any ideas?

Thanks