Possible to delete part of a Header with a Macro?

[smashclash]

I export 30 different files from Peachtree into Excel. I then have a macro that deletes data I do not need. Each file has a slightly different header. I'd like to be able to alter the header in the macro without making the header the same in every macro.

My problem: currently when I go into the page setup and select custom header there is a "& 8" as the first line in the header. I don't know why this is showing up and I haven't found out how to try to delete it from Peachtrees end of the export. When I record the macro I go into page setup and delete the "& 8" however, the macro records the change as text in the header and not as a deletion of the "& 8". Is there a way to have excel delete these 2 characters from the header without the macro giving a fixed header.

 

[Glaswegian]

Hi

Do you mean that the header includes other text as well as "& 8"? And you only want to remove the"& 8"? Or have I misunderstood?

Regards