Hiding Underscore

[rajltd]

I have more than 20 worksheets in some workbook, and the only way I can
differentiate them is through writting the name of the worksheet on the
top as header (header and footer) as most worksheets look similar. But
most of the worksheets have an underscore, eg. ABC_Accessories or
ABC_XYZ_Accessories. And this underscore wont look good in the title
name of the page. Can I write any code (for the header- through VB
macro coding) or is there any utility in Excel to hide the Underscore.

Any help would be appreciated.

Many Thanks,

Raj

 

[ivers]

Maybe try to use invisible space, or would this affect something ?

 

[rajltd]

i cannot use invisible space, otherwise it would be very easy to work
out.