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
|
| All times are GMT +1. The time now is 08:23 PM. |
|
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com
