Another possible reason, that the received data are not of Excel text format.
Try =TEXT(A1,"@") (A1 being the original data).
Regards,
Stefi
€˛Vito€¯ ezt Ć*rta:
Perhaps there are extra spaces in the downloaded data:
Try:
=IF(OR(TRIM(X2)="roll not cut",TRIM(X2)="cut not roll"),"OK to
process", "")
--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=558883