Inconsistant character spaces extraction formula
The following type of data are listed in a column of cells:
Mon 1:30 (4:30)
Mon 10 (1)
Thurs 2 (5)
I need to get the information in parenthasies out, into another cell.
My simple extration formulas aren't working since the character spaces are
inconsistent.
|