are you doing this via a macro or in-cell?

if your doing it in-cell, then use an if equation.

=if(B1="0","0",concatenate(......))

if your doing macro, I'll have to think about it for a minute. If it
is a macro, could you include more info, input, variables, etc...


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=481719