I need to extract certain text and a date from a filename which is stored in a cell.
The value is like this;
Raw Data (For Import only) - Headoffice 01_04_2018 (Late).xlsx
The text I need will be the part that is shown as 'Headoffice' above, (this can vary in text length.
The date I need is...