Jonathan Mori
asked on
Parse a Field in Excel
Hi, I was trying to do this using the "left" "right" and "Len" functions in Excel, but it appears it's a little beyond my abilities at the moment. I was requested to parse out the "GPS_LAT" and "GPS_LONG" fields as shown into 4 separate columns
39° 58' 32.600" N
DEG | MIN | SEC | DEC
39 58 32 600
Also where the Min and Sec column is one Digit they requested a "0" be put in front of it.
Any help is appreciated!
EM-LAB-DATA-WELLS.xls
39° 58' 32.600" N
DEG | MIN | SEC | DEC
39 58 32 600
Also where the Min and Sec column is one Digit they requested a "0" be put in front of it.
Any help is appreciated!
EM-LAB-DATA-WELLS.xls
ASKER
Oh I am so sorry, I posted the wrong spreadsheet, correct one is attached
EM-SITE-DATA-WELLS.xls
EM-SITE-DATA-WELLS.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes! That is perfect, Thank you!
Your welcome
gowflow
gowflow
regards, barry