File name is a cell, not working when uploaded into SharePoint

[Grizlore]

Hi All

Any help appreciated

I am currently using this formula, to have the filename in a cell, works fine. However, when I upload into SharePoint, it doesn't work and returns a #Value! error

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

How can I get around this? Any ideas

Thanks

 

[ExcelGzh]

You might find that the reason is that SharePoint paths are urls with forward slashes. Network paths have back slashes.

Perhaps if you could give some examples of the data that is actually in the cell being analysed.