Thread: [Solved] Volunteer GPS Mapping Project
View Single Post
 
Old 02-13-2014, 09:24 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Since you have a comma separating the latitude & longitude, you could simply use Data>Text to Columns, with a comma delimiter. No formulae required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote