Anyone have a function/macro/formula to give me part of a path. So if my path was /C:/Mydocuments/Ozgrid/Friday/IloveOZ.txt , I would want it to get me /Ozgrid/Friday/IloveOZ.txt. I found formulas to get the end and beggining but not here and that is customizable.
I want to TRIM part of the path, not necessarily till the last "/" maybe the 3rd or 4th. Anyone have anything custom for this?