Assuming your data starts in A1 (change to suit), use this...

=TEXT(MATCH(LEFT(A1,2),{"Su","Mo","Tu","We","Th"," Fr","Sa"},0),"dddd")

and copy down as far as necessary.

Rick


"Sneilan" wrote in message
...
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.