#Newbie
Hi all
I tried to write a sub or a function to populate a selected cell with the formular below:
=SUBSTITUTE(LEFT(CELL("filename"), FIND("]", CELL("filename")) - 1), "[", "")
But i fail. Used examples but no luck.
Beware the formula works only with a saved workbook
anyone?