Where am I going wrong here please... In my workbook there is a lot more text after the word "Attendees:" in cell B3... What I need to extract is "CC 1 (25)"...
Excel WorkbookBC3Record Type: Conclusion. Former Reference: CC 1 (25). Attendees:CC 1 (25). Attendees:Sheet1