Hi everybody,

I have a lot of data and i must make a table which contains these datas with columns and lines. I add a sample on this question:

Distance (m),Elevation (m),Latitude,Longitude
0,56.8672981262207,41.01677,28.91043000000002
9.06985903976427,56.7496452331543,41.0167145559661 ,28.910350556627918


18.13971807952854,56.63394927978516,41.01665911187 766,28.910271113389513

How can i achieve this problem? May you help me?

Thanks..

Try Data - text to columns - use the comma as delimiter - Finish

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks but i use excel in Turkish form and can't find the buttons for ex. "Try Data".

There is no "Try Data" button, which is not what Pecoflyer meant; he said to try:

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Haha, i am probably tired because of the excel problems.

Thank you for answers. My table is ready now.

Distance (m) Elevation (m) Latitude Longitude
0 56,86729813 41,01677 28,91043
9,06985904 56,74964523 41,01671456 28,91035056
18,13971808 56,63394928 41,01665911 28,91027111
27,20957712 56,51824951 41,01660367 28,91019167
36,27943616 56,40255356 41,01654822 28,91011223
45,3492952 56,2868576 41,01649278 28,91003278
54,41915424 56,17116165 41,01643733 28,90995334
63,48901328 56,05546188 41,01638189 28,9098739
72,55887232 55,83678055 41,01632645 28,90979446
81,62873136 55,55168152 41,016271 28,90971501

Ooops , I'll add a : next time

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post