Output Formating is bad in excel - How to sort out?

[Abbas999]

Hi Experts,

I need your help. I am actually converting addresses into GPS coordinates "Longtitudes and Lattitudes". I am using a website where input around 200 addresses and they provide output in a csv. You can see the image below. The formating is little bad. All the data is good but they are not on their accurate location. You can see some part of address like city and zip code is in Latitude and longtitude cell and lattitude and longtitude data is showing in easting and northing cell. Can you suggest a way to keep all in format? Well i don;t need address data as i have to put the gps coordinates from this csv to main csv where all the data is available. I want all the gps coordinates in order as it is in the csv.

 

[Abbas999]

The website sucks, the only way I can see it done is to do it manually or find another website which generates better files. Sorry...

The Website is good, I found a solution myself. If you select a option TABS But not Comma Output You can simply copy the output and paste into excel sheet. It will keep the formatting as it is and It looks very very nice even more simple. Anyway Thank you all of you for looking at my problem. I found Mr-excel a very good helping forum.