Something like:

=if(a1=0,"",a1)&if(b1=0,"",b1)&....

might work.


Karmen wrote:

Sorry, after reading the responses I realized that the sheet I am trying
to combine information on is an automatic fill data sheet which adds
zeros for blank cells from the master sheet....and I had supressed the
zeros showing on the form...I had completely forgot the zero is
actually in the cell, just not showing. with that added information,
is there a way i can combine the cell data and not have the zero show?

--
Karmen
------------------------------------------------------------------------
Karmen's Profile: http://www.excelforum.com/member.php...o&userid=30972
View this thread: http://www.excelforum.com/showthread...hreadid=522413

--

Dave Peterson