Thread: Convert Lats and longs to decimals
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
 
Posts: n/a
Default Convert Lats and longs to decimals
=24*SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE
(A1,"""","")," N",""),"° ",":"),"' ",":")

Reply With QuoteReply With Quote