Centering text in right-side header block

[standard_guy]

Hi,

I had a co-worker ask me if there was a way to center the text in the
right-hand side header block. Normally the left side is left justified, the
right is right justified, and the center is centered. That seems emminently
logical but she wanted to know if you could center the right one in in block.

Thanks

 

[Gord Dibben]

Pad with spaces after the header text.


Gord Dibben MS Excel MVP

 

[PDXUser]

The ability to "pad" on the right side does not work in excel 2010. Is there an alternative method?