I need to read the contents of the left pageheader - no problem:

Titel = ActiveSheet.PageSetup.LeftHeader


Problem occur if the users has change the format of the text!

That way I might get something like this:

Titel = "&""Times New Roman,Bold""&12Expenses 2008"


How to only read the pure text of the header?
(In this case: "Expenses 2008")


Problem is that I cannot know what font, format or size (if any) the user
might have given the header!

Can someone help my???


Thanks,