Home » questions » Excel commands, help please.?

Excel commands, help please.?

2006-08-10 05:04:02, Category: Programming & Design
How can I get the sine of a number if it contains letters. example sin of "S 67°38’ E"? Is this possible? If not, how can I get the sine of "67°38’"? Is it possible to compute this if it has "°" and " ’ "?

Answers

  1. Ed

    On 2006-08-10 05:46:10


    You'll want to convert degrees and minutes to fractional degrees. But you'll also need to change the sign of the angle because it's S. So 67°38’ S becomes -67.6333 degrees. I believe Excel does allow conversion from degrees/minutes into floating point values, but I'm not sure if it'll deal with N/S automatically.
  2. vijju

    On 2006-08-10 05:21:23


    yes u can find sine of this value... i created one excel sheet for that... give me ur mail addresss... i will forward u... first use SEARCH and REPLACE function to replace "°" with. remove " ’ ". and perform sine operation on this value..