Coba rumus
=IF(LEFT(B2)="-","S","N") & ABS(--LEFT(B2,FIND(",",B2)-1)) & " E" &
MID(B2,FIND(",",B2)+1,99)Ada tambahan N kalo lokasinya di lintang utara atau koordinat lintang posistif From: [email protected] [mailto:[email protected]] On Behalf Of heru Purnomo Sent: Tuesday, October 16, 2012 12:09 PM To: [email protected] Subject: ]] XL-mania [[ cara merubah data koordinat Dear master excel; apakah ada yang mengetahui cara merubah data koordinat dari : contoh -3.7989,103.52159 menjadi S3.7989 E103.52159 thanks heru purnomo
<<image001.jpg>>
<<image002.jpg>>
