I am trying to add xy data into ArcGIS from a list of GNIS coordinates. However, the format of the coordinates are Latitude: 342445 and Longitude -1031236 for about 1000+ coordinates. I need to change the format to: 34.2445 and -103.1236 for all of the coordinates so that the there is a decimal after the first two digits and after the first three digits for long. I have a large dataset with the coordinates, but ArcGIS requires the decimal in order to place on a map.
=LEFT(A1,LEN(A1)-4)&"."&RIGHT(A1,4)
=VALUE(LEFT(A1,LEN(A1)-4)&"."&RIGHT(A1,4))
Try one of these
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Hi and welcome to the forum
This is probably way too simplistic, but have you tried...
=A1/10000
copied down and across?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The second formula worked, but I also realized that my data has letters at the end. Is there a batch way to remove letters? Example 344910N convert to 344910 by removing the "N' (north) for a large set of data?
=LEFT(A1,LEN(A1)-1)/10000
Try this one
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks