Hiding Underscore

  • Thread starter Thread starter rajltd
  • Start date Start date
R

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
 
i cannot use invisible space, otherwise it would be very easy to work
out.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word 2007 equations: suppressing underscore->subscript autoformat 4
Autodate worksheet tab 2
Sort excel when workbook opened 2
Hide/Unhide worksheets upon entries in a range of the main worksheet 5
Any way to hide a cell or row from printing? 6
Adding titles to formatted gridded workbook 2
Compatibility Question 3
Add footers in 20 worksheets at once 4

Back
Top