software

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 WishesColin


You can't do that directly in column A without using VBA.

You could use another column, e.g. in C1

=IF(A1=quot;quot;,quot;quot;,A1amp;B1)

copy down to C30. If you wish you could now copy C1:C30 and use Edit gt;
Paste Special gt; Values to paste into A1:A30--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=511573