| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting similar to shading alternating rows | Excel Worksheet Functions | |||
| Remove all formatting | Excel Worksheet Functions | |||
| Can't Insert of remove worksheet in an existing workbook | Excel Discussion (Misc queries) | |||
| cell formatting problems | New Users to Excel | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Threaded Mode
