Excel 2007 : concatenate problem, zero shows when cell is empty

Hi all,

In the attached file, sheet1, C2 is a drop list. This shows records on Sheet2.
When a record is selected fields C9 - C12 are filled.

In fields F10 - F12 needs to be filled with the same data except that F11 combines C10 and C11. This works if there is data in C11, however, if C11 has no data then a zero appears in F11

Any ideas on how to stop a zero from showing?

George

Try this

Please Login or Register  to view this content.

Because there is a formula in C11 it is returning 0 when concatenated.

If you need a separator then try

Please Login or Register  to view this content.

Hope this helps