Excel Commands, Help Please.?
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 " ’ "?
If not, how can I get the sine of "67°38’"?
Is it possible to compute this if it has "°" and " ’ "?
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..
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..
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.
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..
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..