stomped...converting bearings to angles

Hello,    I can usually find a solution to what I am trying to do in excel but I am stomped on this one. I have hundreds of entries that I need to convert from surveyor bearings (like N 37°42'17...