![]() |
|
#1
|
||||
|
||||
![]()
Lat/Lon coordinates (which is what these appear to be) can be negative on either side and span +/- 0-179.9999999999999 degrees. Your coordinates also appear to be limited to a 15-digit precision, so the more digits you have for the integer part, the less you have for the decimal part. Given those parameters, your wildcard Find/Replace expression should probably be:
Find = ([\-0-9.]{16,17}) ([\-0-9.]{16,17}) Replace = [\2,\1] Note: I've assumed your coordinates have trailing 0s
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Steve81uk | Excel | 23 | 05-17-2025 03:22 PM |
![]() |
Deltaj | Word VBA | 2 | 12-04-2014 02:13 PM |
How to parse bold sections of a paragraph? | XmisterIS | Word VBA | 2 | 03-31-2014 02:54 PM |
![]() |
MaxInCO | Word VBA | 5 | 12-11-2013 03:28 PM |
parse, store and email a .tmp file from wordpad? | scadaman29325 | Office | 0 | 09-28-2010 04:56 PM |