How to remove all formatting.
 

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

How to remove all formatting.
 

Copy any single cell that has the formatting that you are looking for and
then select all of the cells on the sheet and Paste Special - Formats...
--
HTH...

Jim Thomlinson


"Rick Wetzel" wrote:

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

How to remove all formatting.
 

Rick,

Select the cells. Edit - Clear - Formats.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Rick Wetzel" wrote in message
...
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