SOLVED

Insertar nombre archivo en una celda

New Contributor

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!!

3 Replies
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.
best response confirmed by MartaSM (New Contributor)
Solution

@MartaSM 

I'd recommend this tool Translator • Excel-Translator (it's free) for formulas translation. In particular for this one it returns

image.png