Thread: Want Cell A1 equal to File name + Worksheet name
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
mubashir aziz[_25_] mubashir aziz[_25_] is offline
external usenet poster
  
Posts: 1
Default Want Cell A1 equal to File name + Worksheet name

This will give you File Name :

=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)

This will give you sheet name :

=REPLACE(CELL("Filename",A1),1,FIND("]",CELL("filename",A1)),"")


--
mubashir aziz

If this post helps Don't 4get to click Yes
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98725

Reply With QuoteReply With Quote