ps. The formula I posted assumes that the extension is 3 characters plus a
The formula David posted assumes that there are no dots in the filename--except
for right before the extension.
Sorry to intrude here, but this is somewhat related. I have the following
formula to place the file name in a cell.
Is there a switch so that the file extension is not shown in the cell?
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
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Vince" wrote in message
The following formula works great if you want the cell name to be the
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