Kevineamon
New Member
- Joined
- Aug 1, 2018
- Messages
- 27
=SUBSTITUTE(REPLACE(CELL("filename",C1),1,FIND("]",CELL("filename",C1)),""), "_test","")
Hi guys
I have this formula above here ^ which I use, to take a part of the name, from the worksheet name and display it in a cell.
I upload this document to my MS OneDrive.
I'd like to use this document with Excel Online, trouble is Excel online seems to be looking for the local FilePath:- C:\users\exceldocs and I'm on different computers.
I wonder if I could point this formula at the onedrive location, where it's stored and just have it work without having to download the excel workbook everytime?
Hi guys
I have this formula above here ^ which I use, to take a part of the name, from the worksheet name and display it in a cell.
I upload this document to my MS OneDrive.
I'd like to use this document with Excel Online, trouble is Excel online seems to be looking for the local FilePath:- C:\users\exceldocs and I'm on different computers.
I wonder if I could point this formula at the onedrive location, where it's stored and just have it work without having to download the excel workbook everytime?
