Thank you very much !!!

Dave Peterson Wrote:
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


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