Computations involving text cells are not working??
 

=IF(c2="ABC",TRUE,FALSE) doesn't do anything
=(a2 & b2) doesn't concatenate 2 text cells
=CONCATENATE(A2,B2) DOESN'T CONCATENATE 2 CELLS

All arithmetic computations seem to work OK

Not sure where the question was, or what the question is, but you can try
putting these in front of the range that contains text (or reference to a
cell that contains a text number): --

Which will for example turn a text string of " 005" to the number 5.






"Text Cell Computations" <Text Cell
wrote in message ...
=IF(c2="ABC",TRUE,FALSE) doesn't do anything
=(a2 & b2) doesn't concatenate 2 text cells
=CONCATENATE(A2,B2) DOESN'T CONCATENATE 2 CELLS

All arithmetic computations seem to work OK

In all cases, what were the values of the cells involved? What answers did
you get?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Text Cell Computations" <Text Cell
wrote in message ...
=IF(c2="ABC",TRUE,FALSE) doesn't do anything
=(a2 & b2) doesn't concatenate 2 text cells
=CONCATENATE(A2,B2) DOESN'T CONCATENATE 2 CELLS

All arithmetic computations seem to work OK