Hi, hopefully, someone can help me with the following. I have a sheet containing the paths and filenames of a large number of .jpg files. Now I want to extract only the path of each file.
I have already split path names into columns. So if I could delete the last cell of each line, my problem would be solved. The number of subdirectories is not the same for all files. Hence, removing one ("last") column of the sheet will not work.
I'm using Excel for Mac, v. 16.43.
Thanks in advance for any pointers.
Bookmarks