Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Phiews
 
Posts: n/a
Default How to put special character "&" in Excel Header / Footer ?

Need help - if my header / footer contains special character "&" in excel -
the result come out incorrect.
Is there any way to put this special character as part of my header / footer
in excel ?

  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How to put special character "&" in Excel Header / Footer ?

Yes, you can definitely include the special character "&" in your Excel header/footer. Here's how you can do it:
  1. Open your Excel worksheet and go to the Insert tab on the ribbon.
  2. Click on the Header & Footer button in the Text group.
  3. This will open the Header & Footer Tools tab. Click on the Header or Footer button, depending on where you want to add the special character.
  4. In the header/footer section, type in the text you want to include, including the "&" character.
  5. To ensure that the "&" character is displayed correctly, you need to use a special code. The code for "&" is "&&" (two ampersands).
  6. So, wherever you want to include the "&" character, type in "&&" instead.
  7. Once you have finished typing in your header/footer text, click on the Close Header and Footer button to return to your worksheet.

That's it! Your header/footer should now display the "&" character correctly. Remember to use "&&" instead of "&" whenever you want to include the special character in your header/footer.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default How to put special character "&" in Excel Header / Footer ?

Use:

&&
--
Gary's Student


"Phiews" wrote:

Need help - if my header / footer contains special character "&" in excel -
the result come out incorrect.
Is there any way to put this special character as part of my header / footer
in excel ?

  #4   Report Post  
Junior Member
 
Posts: 1
Thumbs up

Thank you it helped make output reports more attractive.

MB

Quote:
Originally Posted by Gary''s Student View Post
Use:

&&
--
Gary's Student


"Phiews" wrote:

Need help - if my header / footer contains special character "&" in excel -
the result come out incorrect.
Is there any way to put this special character as part of my header / footer
in excel ?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel needs to let the user set the sort default to "NO HEADER ROW subtleone Excel Worksheet Functions 0 October 8th 05 05:55 PM
How to assign character (text) values to y-axis in a Excel chart? cy Charts and Charting in Excel 1 July 16th 05 10:39 PM
How do I hide the header and footer on page 1 in Excel? Performance Technology Excel Discussion (Misc queries) 1 April 14th 05 09:36 PM
how do I permanetly add custom header to excel header list? GARY Excel Discussion (Misc queries) 1 December 15th 04 09:52 PM
Default header in Excel under page set-up Melanie Excel Discussion (Misc queries) 2 December 15th 04 02:37 AM


All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"