I cannot reproduce this. If I have a blank in B1 then A1&B1&C1 gives the
same as A1&C1
Tell us more
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Karmen" wrote in
message ...

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