View Single Post
  #6   Report Post  
Old January 30th 08, 09:25 PM posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Cell names = sheet names

I'd use 2 cells.

Your formula in A1 and this in B1:
=LEFT(A1,LEN(A1)-4)

But you could make a giant formula if you wanted. Just replace A1 with that
longggggggg formula that you posted.



dc wrote:

Sorry to intrude here, but this is somewhat related. I have the following
formula to place the file name in a cell.

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

Is there a switch so that the file extension is not shown in the cell?

Thanks,
Dave C.

"Vince" wrote:

Thank you! Sometimes the simpe work arounds are the ones that are thought of
last! That works just fine.

"Bernard Liengme" wrote:

A simple workaround
Put that formula in some out of the way cell (IV1) of Sheet3
In Sheet1 B3 enter =Sheet3!IV1
Remember the CELL function need the file to have saved at least once
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Vince" wrote in message
...
The following formula works great if you want the cell name to be the
current
sheet.

=MID(CELL("filename",a1),SEARCH("]",CELL("filename",a1))+1,1024)

Is there a way to reference a different sheet? For example is there a way
for Sheet 1 Cell B3 to show the name of Sheet 3?

Thanks for you help





--

Dave Peterson