Cecil,
=IF(LEFT(A1,3)="ABCD",A1,"")
This will look at the 3 leftmost characters and return a value if it is
true.
Regards,
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=487648