Computations involving text cells are not working??

[Text Cell Computations]

=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

 

[Dave R.]

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.

 

[Niek Otten]

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel