carl Wrote:
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





Highlight the 2 columns, go to Data - Text to columns - click Finish


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=524394