Prefacing a Copy/Paste Special formula with text

  • Thread starter Thread starter Bob Smith
  • Start date Start date
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
 
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
 
Back
Top