Thread: Function to add name of Sheet to a Column?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Function to add name of Sheet to a Column?
Watch it with that particular formula Brad.

With no cell reference it can lead to erroneous returns.

See Bob Phillips' site for more info.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 13:19:01 -0700, Brad
wrote:

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

Success, click yes.

Reply With QuoteReply With Quote