You will see that if you refer to an empty cell on another sheet
="abc" & sheet2!e444
=if(ISBLANK(shee4!c9),"",sheet4!c9) & ...
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Dave Peterson" wrote in message ...
Any 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:
Hello,
I am trying to combine data from various cells into one cell.....using
a formula such as =c9&d9&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: http://www.excelforum.com/member.php...o&userid=30972
View this thread: http://www.excelforum.com/showthread...hreadid=522413
--
Dave Peterson