View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Allllen Allllen is offline
external usenet poster
 
Posts: 341
Default Formula for copying tap info into a cell

=MID(CELL("Filename"),FIND("]",CELL("Filename"))+1,255)
--
Allllen


"James" wrote:

I know there is one, I just cannot remember what it is...I need a formula to
place the text on the tab of a worksheet into a designated cell in the same
worksheet.