I use a third party application that exports data and really wierd
(impossible to work with) formatting to Excel. I currently remove all
formatting by selecting all, copy and then paste into Notepad. Then I delete
everything on the worksheet and do a select all copy from Notepad and a
Paste Special, Text Only back into the worksheet. This works great but is
cumbersome.

Please, is there an easier way? Thanks
--
Rick Wetzel