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

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

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

=IF(A1="","",A1&B1)

copy down to C30. If you wish you could now copy C1:C30 and use Edit
Paste Special Values to paste into A1:A30


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=511573