Look up the MID function in the help menu.
To extract character 6 from a series of characters in D2, replace D2
with MID(D2, 6, 1).
e.g.
=IF(MID(D2, 6, 1)="M","Monday",IF(MID(D2, 6,
1)="T","Tuesday",IF(MID(D2, 6, 1)="W","Wednesday",IF(MID(D2, 6,
1)="R","Thursday",IF(MID(D2, 6, 1)="F",""Friday")))))
Again note that this is using "R" for Thursday ... if you have "Th"
taking up spots 6 and 7, then use:
=IF(MID(D2, 6, 1)="M","Monday",IF(MID(D2, 6,
1)="T","Tuesday",IF(MID(D2, 6, 1)="W","Wednesday",IF(MID(D2, 6,
2)="Th","Thursday",IF(MID(D2, 6, 1)="F",""Friday")))))
--
William DeLeo
------------------------------------------------------------------------
William DeLeo's Profile:
http://www.excelforum.com/member.php...fo&userid=1256
View this thread:
http://www.excelforum.com/showthread...hreadid=382076