Select All/ Copy, Edit/ Paste Special/ Values.
--
David Biddulph

"Frank" wrote in message
...
Is there an easy way to import data from an (ugly) Excel Spreadsheet which
I
will call "the raw data" into my (pretty) Excel Spreadsheet with nice
formatting.
I need to do this once a month.
The data is the all same (oh, ok there's some extraneous data in the "raw"
one - some extra columns - but I can delete those columns either before
importing or after).
Thanks!
Frank