Single Quote use in cell reference

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 07 May 2008 17:05 GMT

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,

Reply to this Message

Reitanos - 07 May 2008 17:19 GMT

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.

> 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
[quoted text clipped - 7 lines]
>
> Thank You,

Reply to this Message