concatenate contents of cells whose contents resemble cell referem
Try this:
=IF(COUNTA(A1:B1)=2,A1&B1,"")
--
Biff
Microsoft Excel MVP
"cathyh" wrote in message
...
cell A1 contains the value A
cell B1 contains the value 5
in cell C1, i want to concatenate the contents of cell A1 and cell B1 so
that the answer would be A5
because the values resemble cell references, i'm having trouble.
any ideas?
|