View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
N Harkawat N Harkawat is offline
external usenet poster
 
Posts: 55
Default In Excel, how do I make a cell equals the sheet name?

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,99)


"Dallas, TX" wrote:

My worksheet name is BU300, I want the value of a specific cell, in the same
worksheet, to be BU300, without me having to type it. Is there a formula to
do it?