I am guessing this is one of those instants where Test to Columns may
help. Apply Data - Test to columns - Finish to the 2 columns
Summary!C and AMS!B.
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=524394