Thank you. Not sure what you are refering to. can you please elaborate ?

"Morrigan" wrote:


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