Single Quote use in cell reference

E

Eric

I am trying to decifer a spreadsheet prepared by someone who has left the
company. They used the following cell reference, which appears to reference
an outside spreadsheet without using the full spreadsheet name, ='AR
''06'!G414.

What do the two separate items in single quotes do. I can't figure out what
'AR ''06' is?

Any thoughts are greatly appreciated.

Thank You,
 
R

Reitanos

Excel uses the single quotes around a sheet name that includes spaces,
but because the author of the document named the sheet AR '06 (using
the apostrophe to indicate the missing 20 from 2006) Excel had to add
the second apostrophe.
 

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

Top