Convert latitude and longitude coordinates in excel
I have about 10,000 coordinates I need to convert. The coordinates are in this format:
-116.6412722 34.7459017 -116.8066783 34.7734247
I need a way to convert them into this format, preferably in excel so I can do it in a batch:
N033.40.47.638 W117.51.48.032 N033.40.47.456 W117.51.47.881
I'm fairly new to excel, so if someone could help me out, I would greatly appreciate it.
I have about 10,000 coordinates I need to convert. The coordinates are in this format:
-116.6412722 34.7459017 -116.8066783 34.7734247
I need a way to convert them into this format, preferably in excel so I can do it in a batch:
N033.40.47.638 W117.51.48.032 N033.40.47.456 W117.51.47.881
I'm fairly new to excel, so if someone could help me out, I would greatly appreciate it.
No comments:
Post a Comment