Macropod
Thank you for your help. This search and replace worked on some lines and not others (maybe because my file names contained hyphens, don't know).
But anyway I should have requested that this thread be closed because I found a solution in the Excel forum in an existing post titled word up to last "\"
Carol