Hello again, all. I’m having a mental block today and was hoping someone could help out. I have a column in my spreadsheet that contains a path and filename (e.g, /home/grey/Documents/LOWriter/filename.ods). To be clear, this column contains text and not references/hyperlinks to the files. I would like to trim the text down to “filename.ods” in an adjacent column. What would be the correct function/formula to do so?
I know one of you geniuses know! Thanks!