Hi

I have a problem which I need to solve.

In Column A 1-30 I have some cells containing a number and some cells
are empty.

In column B 1-30 I have text in every cell.

I need to concatenate the two columns , but only where columns A and B
both have content.

I need the blank cells in A to remain blank after the concatenation ,
and those that have content to be successfully concatenated with the
equivalent cell column B - is this possible?

Grateful for any help.



Best Wishes


Colin