the Tilde is a special character in Excel..
So to do a search, put another Tilde in front of it..
5CQ-MKPCTCC^~~CC^~~5CQ-CCCAMPBW
This is also true with the * and ?
--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile:
http://www.excelforum.com/member.php...o&userid=35016
View this thread:
http://www.excelforum.com/showthread...hreadid=558518