hello guys

[Mishoshow]

I need to Change cell name to File Name without changing formatting cell is that possible ?? I already change the cell name but the formatting of cell doesn't work with any equation.

=TRIM(LEFT(SUBSTITUTE(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),".xl",REPT(" ",255)),255))

 

[SunnyAlv]

What are the contents of cell A1?

 

[Mishoshow]

What are the contents of cell A1?

a number

 

[Peter_SSs]

What exactly are you trying to do?

 

[Mishoshow]

What exactly are you trying to do?

I'm trying to use xlookup after changing the cell with file name ,, but after changed to file name xlookup doesn't work cuz the cell isn't a number

 

[SunnyAlv]

a number

At least photo or something According to what defines the number

 

[RoryA]

If the file name is a number, add +0 to the end of your formula.

 

[Mishoshow]

If the file name is a number, add +0 to the end of your formula.

thanks

 

[Peter_SSs]

As well as Rory's suggestion, if you are using your 365 version you can get the file name a bit easier like this

=TEXTAFTER(TEXTBEFORE(CELL("filename",A1),".xl"),"[")+0