[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

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
0
GravitaZ24
Asked:
GravitaZ24
  • 2
  • 2
1 Solution
 
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
 
gowflowCommented:
Is this what your looking for ? Col U to AB
gowflow
EM-SITE-DATA-WELLS.xls
0
 
GravitaZ24Author Commented:
yes! That is perfect, Thank you!
0
 
gowflowCommented:
Your welcome
gowflow
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now