Thread: Bruno Thank you... But I have another question - "Test.xlsx" 8872 Bytes yEnc
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bruno Campanini[_2_] Bruno Campanini[_2_] is offline
external usenet poster
  
Posts: 74
Default Bruno Thank you... But I have another question - "Test.xlsx" 8872 Bytes yEnc
It happens that formulated :
I found some coordinates in a different format then what I stated in the
previous message.
I have frequencies in the degree, minute, second (decimal). Please look at
the file I attached.
I want to take the red coordinates and transfer them to green.


That's for Latitude:
=(-2*(RIGHT(D2,1)="S")+1)*(MID(D2,1,SEARCH("°",D2,1)-1)+MID(D2,SEARCH("°",D2,1)+1,2)/60+(MID(D2,SEARCH("'",D2,1)+1,LEN(MID(D2,SEARCH("' ",D2,1)+1,9))-2))/3600)

That's for Longitude:
=(-2*(RIGHT(E2,1)="W")+1)*(MID(E2,1,SEARCH("°",E2,1)-1)+MID(E2,SEARCH("°",E2,1)+1,2)/60+(MID(E2,SEARCH("'",E2,1)+1,LEN(MID(E2,SEARCH("' ",E2,1)+1,9))-2))/3600)

Bruno


Reply With QuoteReply With Quote