MrExcel Publishing
Your One Stop for Excel Tips & Solutions

R&D in a footnote

Posted by Greg Banerian on January 22, 2002 1:37 AM

This should be a no brainer, but it seems I'm all outta braincells.

I simply want to hardcode "R&D" (without the quotes) in a footnote but excel interprets the &D part to put in today's Date.

I got around this by naming the sheet R&D and using the sheetname, which is fine with a one-sheet file, but the file is multiple sheets.

Can anyone tell me how to hardcode this into the footnote?

Posted by JohnA on January 22, 2002 1:53 AM

See Tip in the Excel Help File:

"To include a single ampersand (&) within the text of a header or footer, use two ampersands. For example, to include "Subcontractors & Services" in a header, type Subcontractors && Services."



Posted by Greg on January 22, 2002 2:03 AM

Thanks for the quick response, John.