If the format of the cell containing the letter is always the same, then
you could use the MID function. For example, if the cell contained "T
M", and you are looking at the M to designate Monday, then replace the
D2 with:

MID(D2,3,1)

Note that spaces are counted so this formula is counting from the left
3 characters (T,space,M) and returing 1 character starting with the M
... i.e. just M.

Look up the RIGHT, LEFT and MID functions. One of those should do the
trick.


--
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