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
GravitaZ24Asked:
Who is Participating?
 
gowflowCommented:
Is this what your looking for ? Col U to AB
gowflow
EM-SITE-DATA-WELLS.xls
0
 
barry houdiniCommented:
I don't see those columns - is this the correct workbook?

regards, barry
0
 
GravitaZ24Author Commented:
Oh I am so sorry, I posted the wrong spreadsheet, correct one is attached
EM-SITE-DATA-WELLS.xls
0
 
GravitaZ24Author Commented:
yes! That is perfect, Thank you!
0
 
gowflowCommented:
Your welcome
gowflow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.