Forum Discussion
Solved
problem entering file name without extension in a cell
=MID(CELLULE("filename"),CHERCHE("[",CELLULE("filename"))+1, CHERCHE("]",CELLULE("filename"))-CHERCHE("[",CELLULE("filename"))-1) this formula picked on microsoft excel dont work
Try this;
=STXT(CELLULE("filename");CHERCHE("[";CELLULE("filename"))+1;(CHERCHE("]";CELLULE("filename"))-5)-(CHERCHE("[";CELLULE("filename"))+1))
Try this;
=STXT(CELLULE("filename");CHERCHE("[";CELLULE("filename"))+1;(CHERCHE("]";CELLULE("filename"))-5)-(CHERCHE("[";CELLULE("filename"))+1))
it work! thanks a lot!! have a great day!