Not sure if this will cause you more work, but it should remove ALL formatting/styles.
Left-click in the small square abobe row 1 and to the left of column A
On the Home Tab/Editing/Clear/Clear Formats
Thanks Ford - though as I mentioned in point 2, I can't do that unfortunately. It would me a ridiculous amount of rework. A shame that all these styles get copied over - quite an inconvenience.
Bookmarks