software

Hello,
I am trying to combine data from various cells into one cell.....using
a formula such as =c9amp;d9amp;e9 however if one of the cells were blank I
get a 0 in the end combination. What can I do to eliminate the zero?

Or pehaps there is a better way to do this. I have text and numbers in
15 rows / 4 columns. I would like to enter into a separate cell the
combined information from row a1:d1 then a2:d2 etc.

Unfortunately today, I can not seem to think of a better solution. any
suggestions?--
Karmen
------------------------------------------------------------------------
Karmen's Profile: www.excelforum.com/member.php...oamp;userid=30972
View this thread: www.excelforum.com/showthread...hreadid=522413I cannot reproduce this. If I have a blank in B1 then A1amp;B1amp;C1 gives the
same as A1amp;C1
Tell us more
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Karmenquot; gt; wrote in
message ...
gt;
gt; Hello,
gt; I am trying to combine data from various cells into one cell.....using
gt; a formula such as =c9amp;d9amp;e9 however if one of the cells were blank I
gt; get a 0 in the end combination. What can I do to eliminate the zero?
gt;
gt; Or pehaps there is a better way to do this. I have text and numbers in
gt; 15 rows / 4 columns. I would like to enter into a separate cell the
gt; combined information from row a1:d1 then a2:d2 etc.
gt;
gt; Unfortunately today, I can not seem to think of a better solution. any
gt; suggestions?
gt;
gt;
gt; --
gt; Karmen
gt; ------------------------------------------------------------------------
gt; Karmen's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30972
gt; View this thread: www.excelforum.com/showthread...hreadid=522413
gt;

=CONCATENATE(A1,B1,C1)

I also couldn't reproduce your results, but this should work.

Karmen Wrote:
gt; Hello,
gt; I am trying to combine data from various cells into one cell.....using
gt; a formula such as =c9amp;d9amp;e9 however if one of the cells were blank I
gt; get a 0 in the end combination. What can I do to eliminate the zero?
gt;
gt; Or pehaps there is a better way to do this. I have text and numbers in
gt; 15 rows / 4 columns. I would like to enter into a separate cell the
gt; combined information from row a1:d1 then a2:d2 etc.
gt;
gt; Unfortunately today, I can not seem to think of a better solution. any
gt; suggestions?--
kevindmorgan
------------------------------------------------------------------------
kevindmorgan's Profile: www.excelforum.com/member.php...oamp;userid=32232
View this thread: www.excelforum.com/showthread...hreadid=522413Any chance that one of the cells actually contains a 0, but is hidden by
formatting--either a custom format or format|conditional formatting or just
font/fill color?

If you select each cell, what do you see in the formula bar?

Karmen wrote:
gt;
gt; Hello,
gt; I am trying to combine data from various cells into one cell.....using
gt; a formula such as =c9amp;d9amp;e9 however if one of the cells were blank I
gt; get a 0 in the end combination. What can I do to eliminate the zero?
gt;
gt; Or pehaps there is a better way to do this. I have text and numbers in
gt; 15 rows / 4 columns. I would like to enter into a separate cell the
gt; combined information from row a1:d1 then a2:d2 etc.
gt;
gt; Unfortunately today, I can not seem to think of a better solution. any
gt; suggestions?
gt;
gt; --
gt; Karmen
gt; ------------------------------------------------------------------------
gt; Karmen's Profile: www.excelforum.com/member.php...oamp;userid=30972
gt; View this thread: www.excelforum.com/showthread...hreadid=522413

--

Dave Peterson

You will see that if you refer to an empty cell on another sheet
=quot;abcquot; amp; sheet2!e444

=if(ISBLANK(shee4!c9),quot;quot;,sheet4!c9) amp; ...

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Dave Petersonquot; gt; wrote in message ...
gt; Any chance that one of the cells actually contains a 0, but is hidden by
gt; formatting--either a custom format or format|conditional formatting or just
gt; font/fill color?
gt;
gt; If you select each cell, what do you see in the formula bar?
gt;
gt; Karmen wrote:
gt; gt;
gt; gt; Hello,
gt; gt; I am trying to combine data from various cells into one cell.....using
gt; gt; a formula such as =c9amp;d9amp;e9 however if one of the cells were blank I
gt; gt; get a 0 in the end combination. What can I do to eliminate the zero?
gt; gt;
gt; gt; Or pehaps there is a better way to do this. I have text and numbers in
gt; gt; 15 rows / 4 columns. I would like to enter into a separate cell the
gt; gt; combined information from row a1:d1 then a2:d2 etc.
gt; gt;
gt; gt; Unfortunately today, I can not seem to think of a better solution. any
gt; gt; suggestions?
gt; gt;
gt; gt; --
gt; gt; Karmen
gt; gt; ------------------------------------------------------------------------
gt; gt; Karmen's Profile: www.excelforum.com/member.php...oamp;userid=30972
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=522413
gt;
gt; --
gt;
gt; Dave Peterson

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: www.excelforum.com/member.php...oamp;userid=30972
View this thread: www.excelforum.com/showthread...hreadid=522413Something like:

=if(a1=0,quot;quot;,a1)amp;if(b1=0,quot;quot;,b1)amp;....

might work.Karmen wrote:
gt;
gt; Sorry, after reading the responses I realized that the sheet I am trying
gt; to combine information on is an automatic fill data sheet which adds
gt; zeros for blank cells from the master sheet....and I had supressed the
gt; zeros showing on the form...I had completely forgot the zero is
gt; actually in the cell, just not showing. with that added information,
gt; is there a way i can combine the cell data and not have the zero show?
gt;
gt; --
gt; Karmen
gt; ------------------------------------------------------------------------
gt; Karmen's Profile: www.excelforum.com/member.php...oamp;userid=30972
gt; View this thread: www.excelforum.com/showthread...hreadid=522413

--

Dave Peterson


Thank you very much !!!

Dave Peterson Wrote:
gt; Something like:
gt;
gt; =if(a1=0,quot;quot;,a1)amp;if(b1=0,quot;quot;,b1)amp;....
gt;
gt; might work.
gt;
gt;
gt; Karmen wrote:
gt; gt;
gt; gt; Sorry, after reading the responses I realized that the sheet I am
gt; trying
gt; gt; to combine information on is an automatic fill data sheet which adds
gt; gt; zeros for blank cells from the master sheet....and I had supressed
gt; the
gt; gt; zeros showing on the form...I had completely forgot the zero is
gt; gt; actually in the cell, just not showing. with that added
gt; information,
gt; gt; is there a way i can combine the cell data and not have the zero
gt; show?
gt; gt;
gt; gt; --
gt; gt; Karmen
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Karmen's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30972
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=522413
gt;
gt; --
gt;
gt; Dave Peterson--
Karmen
------------------------------------------------------------------------
Karmen's Profile: www.excelforum.com/member.php...oamp;userid=30972
View this thread: www.excelforum.com/showthread...hreadid=522413