English, Tutorials

Extracting Geographic Coordinates from Spreadsheet Cells [and Converting THEM]

Geographic coordinates are numbers used to locate elements, objects, places (etc) on the Earth’s surface. Our planet is vertical and horizontally divided in angles, which are called longitude and latitude, respectively.

Spreadsheets are a very good way to arrange a great range of information, including coordinates. But if they are used carelessly, it can bring headaches from other planets… Especially if you want to extract a piece of information from a cell, i.e. remove useless information.

Suppose you have a huge spreadsheet with many geographic coordinates (e.g. 28°40′39″S 49°22′11″W) and you need to separate the degrees, minutes and seconds from each other. This is necessary, if your GIS software only accepts decimal degrees. One way (the hardest way), is to edit each cell and copy and paste to another cell… boring and time consuming. Another way is to create a function (formula) that can do this for us!

Continue reading “Extracting Geographic Coordinates from Spreadsheet Cells [and Converting THEM]”

Advertisements