I have a massive spreadsheet with a field that gives the file path. But now I am trying to find a way to just have the file name and get rid of everything to the left of the last "\". The hard part is that the amount of "\" in each row vary. Can anyone help me out?
Here is an example of a field:
...\Hydraulic Fittings\37 degree flare tube fittings\JIC cap nut_0304.tif (All I want is in bold).
...\Dixon Speciality Hose\PTFE convoluted non-conductive hose.tif
Like I said earlier, some of the rows vary in the amount of "\"'s they have.
Any response is appreciated.
P.S. I tried a between formula but the it reads the first "\".