MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
I have a table of waypoints that I have converted from E/N to Lat/Long.
They are saved in an Excel CSV file, each pair of co-ordinates are in a single cell separated by a comma. As picture below.
[img][url= https://image.ibb.co/jZ3B7Q/stw_table.jp g" target="_blank">https://image.ibb.co/jZ3B7Q/stw_table.jp g"/> [/img][/url][/img]
I have tried to import into Google Earth but it doesn't seem to recognise the comma as a seperator and can't distinguish between the lat and long.
I have also tried GPS Babel and Garmin Mapsource with no success.
I have done similar tasks in the past without a problem but I can't seem to get this work now.
Any suggestions?
Can you concatenate the excel file to the format that google will get?
Can you concatenate the excel file to the format that google will get?
Is there a function to separate the 2nd value and put in it's own cell?
Your CSV is messed up. Both the lat and lon and the comma between them is in one column so is treated as one value.
If you edit the .csv with a text editor e.g. wordpad, what does the data look like ?
you can find the position of the comma then do a left/right to get the 2 numbers out or import the CSV into excel and the auto import will seperate on the comma into 2 cells
Fixed it. Got the data in separate cells.
Thanks for all your help.