Hi Bob thanks for the reply,

My data example is not correct. I have variable length data with leading zeros. Data can have no leading zero, 1 zero, and sometimes more that 1 zero. I want to keep all of the zeros because my DB2 database has a text field with the leading zeros. If I strip out the zeros I will not be able to find the index in DB2. All I can tell you about the spreadsheet is that the zeros are there and that the cells are formated as Custom ########0. If I change the cells to text it strips the zeros. I'm using office 2010.

Data looks like this.

aaa 012345

bbb 00050556

ccc 0012367

ddd 052525252

eee 529820343

I need to concatenate the 'numeric' text field and keep the zeros. End result will eventually be '052525252' and '0012367' so it would work to put apost around the data as well but everything I try strips out the zeroes.

Frank