Forum Discussion
txt to excel
Hello I have in my documents a txt file with coordinates i want to import this file in excel. If i do this now than the coordinates stand like this 123.456.789 and i want it in 123456.789. ...
If your imported data is in column A, please paste this formula in B2
=SUBSTITUTE(A2,".","")/1000
you can drag this formula to all the data rows.
hope this will work. if there further questions, please upload a sample data file. it will help to analyse the issues.
thank you for your anwser.
the formule works, only te nummer after putting the formule is 12345,678 and not 12345.678
the numbering in excel is 12.345.678 and after the formule the "." is changed in ","
is there a method to change that?
thanks for now.
