SOLVED

Insertar nombre archivo en una celda

%3CLINGO-SUB%20id%3D%22lingo-sub-2412101%22%20slang%3D%22es-ES%22%3EInsert%20file%20name%20into%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2412101%22%20slang%3D%22es-ES%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3EI%20need%20to%20translate%20this%20formula%20into%20Spanish%20and%20I%20don't%20get%20it%3A%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DMID(CELL(%22filename%22)%2CSEARCH(%22%5B%22%2CCELL(%22filename%22))%2B1%2C%20SEARCH(%22%5D%22%2CCELL(%22filename%22))-SEARCH(%22%5B%22%2CCELL(%22filename%22))-1)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you!!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2412101%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2412489%22%20slang%3D%22en-US%22%3ERE%3A%20Insertar%20nombre%20archivo%20en%20una%20celda%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2412489%22%20slang%3D%22en-US%22%3Ethe%20CELL%20function%20can%20return%20various%20information%20and%20in%20this%20case%20it%20is%20returning%20the%20%22filename%22.%20But%20the%20%22filename%22%20is%20actually%20a%20full%20path%20to%20that%20cell%20in%20this%20format%3A%20Absolute_file_path%5Bfilename%5Dsheetname%20So%20the%20MID%20function%20will%20take%20a%20string%20(the%20above%20full%20path)%20and%20return%20just%20the%20middle%20part%20based%20on%20a%20starting%20position%20(the%201st%20SEARCH%20finds%20the%20location%20of%20the%20%22%5B%22)%20and%20a%20length%20(the%202nd%20search%20for%20%22%5D%22%20minus%20the%203rd%20search%20for%20the%20%22%5B%22%20again)%20So%20it%20will%20return%20the%20MID%20part%20of%20the%20full%20path%20that%20is%20between%20the%20%22%5B%22%20and%20%22%5D%22%20characters%2C%20which%20is%20the%20actual%20filename.%20Hope%20that%20helps%3C%2FLINGO-BODY%3E
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