get path for subfolder

[twistsd]

I have an excel file stored on OneDrive in a folder, which has a subfolder called FolderA which has subfolders called site1, site2 etc. I can get the file path for the main file to display in a cell and then concatenate and add the subfolders into another cell. The issue I have is sometimes my pc opens the file and the path is C:\\folder..... and other times its https://onderivefolder, the problem is the "/" & "\" in the concatenate and how to get the correct one depending upon which path type is displayed. Any help on how to best address this would be gratefully appreciated.
Thanks

 

[Akuini]

@twistsd
Windows use "\" as the default but "/" works too.
For example in VBA, both works:

Workbooks.Open "D:\MY DONLOT\561414 - test 1.xlsm"

Workbooks.Open "D:/MY DONLOT/561414 - test 1.xlsm"

maybe you can manipulate it in your formula.