On Wed, 7 Dec 2005 17:30:38 -0600, catalfamo1220
wrote:
I have a set of files which I need to change the formatting of. The
following is a "snippet" from the file.
LINE !
GP 43 20 55.8104 071 00 21.9000 !
GP 43 22 55.9808 071 00 21.9000 !
LINE !
GP 42 20 26.3693 069 39 27.1135 !
GP 42 20 24.4404 069 36 45.5376 !
LINE !
GP 41 20 53.1930 071 00 21.9000 !
GP 41 18 53.3019 071 00 21.9000 !
LINE !
GP 42 20 26.3693 072 21 16.6865 !
GP 42 20 24.4404 072 23 58.2624 !
LINE !
GP 42 04 54.7989 072 13 28.5131 !
GP 42 03 21.2430 072 20 22.2052 !
LINE !
GP 43 15 19.9995 071 21 43.4900 !
GP 43 20 29.4271 071 23 47.0573 !
LINE !
GP 42 36 07.9703 069 46 39.0272 !
GP 42 37 32.2043 069 39 38.1326 !
LINE !
GP 41 26 25.2752 070 39 36.5962 !
GP 41 21 15.2893 070 37 40.2406 !
LINE !
GP 43 22 25.0574 072 25 21.6600 !
GP 43 22 25.0574 069 35 22.1399 !
LINE !
GP 43 22 25.0574 069 35 22.1399 !
GP 41 18 23.3610 069 38 06.2447 !
LINE !
GP 41 18 23.3610 069 38 06.2447 !
GP 41 18 23.3610 072 22 37.5553 !
LINE !
GP 41 18 23.3610 072 22 37.5553 !
GP 43 22 25.0574 072 25 21.6600 !
LINE !
GP 42 20 26.3693 069 39 27.1135 !
GP 42 19 06.7204 069 39 29.9999 !
GP 42 17 47.1379 069 39 35.2571 !
GP 42 16 27.6609 069 39 42.8798 !
GP 42 15 08.3279 069 39 52.8620 !
GP 42 13 49.1778 069 40 05.1963 !
What I need Excel (or any other fesable ways of doing this) to do is
get this coordinate data in a format like such:
N043.20.55.810 W071.00.21.900 N043.22.55.981 W071.00.21.900
N042.20.26.369 W069.39.27.114 N042.20.24.440 W069.36.45.538
N041.20.53.193 W071.00.21.900 N041.18.53.302 W071.00.21.900
What happens is as follows:
1. 1st two *digits* get a "N0" to proceed them
2. A decimal is added after the first 2, second, and third digits
3. If there's 4 digits in the 4th set of numbers, it gets divided by 10
and rounded to nearest tens place
4. Same happens for the other 4 "sets"
5. Every other line of coordinates gets added directly after the one
before it
Anyone confused yet? 
Let me know if further explanation is
necessary.
Would Excel be a fesable solution to this? If not, can someone point me
to the right direction?
Thanks for your patience.
Mike Catalfamo
Are the latitudes and longitudes in one cell or two cells initially?
Do you want the output to be in individual cells or all four combined into one
cell?
--ron