Hi all,
I am looking for a formula that will find the last dash ("-" character) in a cell, which allows me to use that in a RIGHT or MID function to isolate that cell contents right of that "-" character into a new cell.
E.g.
Cell A1: "Abbar & Zainy Cold Stores-Maintenance-Warehouse Maintenance Manager.doc"
Using the formula, cell B1 would contain "Warehouse Maintenance Manager.doc"
Many thanks,
Basz
Bookmarks