MrHelpRequired
New Member
- Joined
- Jul 31, 2014
- Messages
- 2
Hi All,
Thanks in advance for any help. I have trawled through Google search results and this forum before signing up and starting my own thread.
I have a large number of waypoint files (garmin .wpt) which periodically require editing. Currently all the data for each waypoint (lats/longs/date etc) appear in the first cell. I have worked out how to separate them into cells/columns using the 'data tab - from text or text to columns'. I have not been able to find a way to have this occur by default each time I open a file. I have also found a related thread about saving preferences as a template but I'm not sure that would work in this case and as I am on a work computer, I don't have the necessary permissions to save the template file in the Office14 or Office15 folders as was suggested.
The way the files are used and I would like them to work is that I can open them directly from windows explorer and have the data for each entry sit in individual cells - we have a whole lot of copying and pasting to do for a large mapping project at the minute so could really do without the extra steps.
I'm actually trying to sort this out for my supervisor who believes that as of a couple of days ago when he opened the files the data appeared in multiple files - I have no way of confirming this and he is fairly computer illiterate and I can't be entirely sure that this is true or what he may or may not have done. The only thing that has changed in the interim is that on his computer the wpt file type wasn't associated with excel so I fixed that.
Any help keeping myself and my supervisor happy will be much appreciated.
Regards
MrHelpRequired
Thanks in advance for any help. I have trawled through Google search results and this forum before signing up and starting my own thread.
I have a large number of waypoint files (garmin .wpt) which periodically require editing. Currently all the data for each waypoint (lats/longs/date etc) appear in the first cell. I have worked out how to separate them into cells/columns using the 'data tab - from text or text to columns'. I have not been able to find a way to have this occur by default each time I open a file. I have also found a related thread about saving preferences as a template but I'm not sure that would work in this case and as I am on a work computer, I don't have the necessary permissions to save the template file in the Office14 or Office15 folders as was suggested.
The way the files are used and I would like them to work is that I can open them directly from windows explorer and have the data for each entry sit in individual cells - we have a whole lot of copying and pasting to do for a large mapping project at the minute so could really do without the extra steps.
I'm actually trying to sort this out for my supervisor who believes that as of a couple of days ago when he opened the files the data appeared in multiple files - I have no way of confirming this and he is fairly computer illiterate and I can't be entirely sure that this is true or what he may or may not have done. The only thing that has changed in the interim is that on his computer the wpt file type wasn't associated with excel so I fixed that.
Any help keeping myself and my supervisor happy will be much appreciated.
Regards
MrHelpRequired
