View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Ryan Bob Ryan is offline
external usenet poster
 
Posts: 8
Default Auto insert sheetname into chart title?

Got it, and then realized I can put the text that will never change in
one cell, the sheet name formula in another cell and either use the
concatenate function or "&" to combine the two, which would then feed
the chart title. Thank you.
Bob

On 5/9/2010 9:05 AM, Don Guillett wrote:
Just amend your cell formula to
="Total Income for " &
MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)