| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data format coversion in Excel (long)
I have a set of files which I need to change the formatting of. Th 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 i 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 1 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 on before it Anyone confused yet?  Let me know if further explanation inecessary. Would Excel be a fesable solution to this? If not, can someone point m to the right direction? Thanks for your patience. Mike Catalfam -- catalfamo122 ----------------------------------------------------------------------- catalfamo1220's Profile: http://www.excelforum.com/member.php...fo&userid=2945 View this thread: http://www.excelforum.com/showthread.php?threadid=49167 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Interrupting long calculations in Excel? Hi all, I am having a verylong calculation in Excel using VBA. Of course I know I can hit ESC orCTRL+BREAK to interrupt the VBA program. But I found due to too long runningprocess, the Excel window stop to | Excel Discussion (Misc queries) | |||
| Does Excel have a cell format for lat/long in ° min sec format? | Excel Discussion (Misc queries) | |||
| Text Time Coversion Arithmatic | Excel Discussion (Misc queries) | |||
| cell format in Excel 2002 SP3 will not accept long numbers | Excel Worksheet Functions | |||
| Coversion Of Fractions To Percentages | Excel Discussion (Misc queries) | |||
![catalfamo1220[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
