Prefacing a Copy/Paste Special formula with text

B

Bob Smith

Hi folks,

I've got two workbooks linked. Am trying to pull a date from one workbook
into another, and would like to preface the copy/paste special data with "As
of" in the cell.

Can anyone suggest a fix?

TIA,

Bob
 
J

Joerg

Not sure what you mean: Why would you copy/paste special if the sheets are
linked?
Otherwise a link such as: ="As of "&Sheet2!A1
Joerg
 
Top