Hi

I'm hoping I can get some help with my question.

I have a report which is essentially text, it includes a bunch of stuff including dates, times and percentages. The way the data appears on the report is strings of text like this:

From: 05/16/08 IEX TotalView Summary
To: 05/16/08 Consumer Sales Daily
Shift: 0 All Day Time Utilization Report Page: 1


MU: 202 Adelaide Saves
Time Zone: Australia/South
Report Across Agent Moves: No Report Agent Moves: No
Include Codes: ALL
Sort By Exception Code Group: No
Show Exception Code Group Totals For Selected Exception Codes: No
Show Exception Code Details: No

Duration
Exception Code HH:MM Percent

Summary Data For: Date: 05/16/08

Total Agents: 139



When I paste it into Excel the first time, it pastes it in as text (unformatted). This is the way I want it pasted in as then I am able to run a prerecorded macro that formats it the way I want.

When I go to paste the report in a second time (as it needs to be run twice), it is formatted into columns. How can I get Excel to not do this and treat it as text? I have tried Paste Special…Text and Paste Special...Unicode Text.


If anyone can help that would be great
Thanks very much