Forum Discussion
Solved
Insertar nombre archivo en una celda
Hola!
Necesito traducir esta fórmula al español y no me sale:
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)
Gracias!!
I'd recommend this tool Translator • Excel-Translator (it's free) for formulas translation. In particular for this one it returns
3 Replies
I'd recommend this tool Translator • Excel-Translator (it's free) for formulas translation. In particular for this one it returns
- the CELL function can return various information and in this case it is returning the "filename". But the "filename" is actually a full path to that cell in this format: Absolute_file_path[filename]sheetname So the MID function will take a string (the above full path) and return just the middle part based on a starting position (the 1st SEARCH finds the location of the "[") and a length (the 2nd search for "]" minus the 3rd search for the "[" again) So it will return the MID part of the full path that is between the "[" and "]" characters, which is the actual filename. Hope that helps
- La parte de la función la entiendo, pero no da el resultado, me sale como que es volátil y no da resultado.
