Extracting abbreviated days, converting to full word
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 day into another cell and converted to a full day name:
Mon = Monday
My simple extration formulas aren't working since the abbreviated days very
from 3-4 character spaces.
|