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

Grizlore

Active Member
Joined
Aug 22, 2006
Messages
257
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
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

ExcelGzh

Board Regular
Joined
Mar 29, 2020
Messages
57
Office Version
365
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,509
Messages
5,469,038
Members
406,629
Latest member
Alan365

This Week's Hot Topics

Top