Home

txt to excel

%3CLINGO-SUB%20id%3D%22lingo-sub-777025%22%20slang%3D%22en-US%22%3Etxt%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777025%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20in%20my%20documents%20a%20txt%20file%20with%20coordinates%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20want%20to%20import%20this%20file%20in%20excel.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20i%20do%20this%20now%20than%20the%20coordinates%20stand%20like%20this%20123.456.789%20and%20i%20want%20it%20in%20123456.789.%3C%2FP%3E%3CP%3EIs%20there%20a%20special%20formula%20or%3F%3C%2FP%3E%3CP%3EOr%20must%20i%20chains%20some%20settings%20in%20the%20text%20wizard%3F%3C%2FP%3E%3CP%3EI%20don%60t%20no%20what%20to%20do%20right%20now...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-777025%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-777066%22%20slang%3D%22en-US%22%3ERe%3A%20txt%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777066%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383566%22%20target%3D%22_blank%22%3E%40ronmas200%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20your%20imported%20data%20is%20in%20column%20A%2C%20please%20paste%20this%20formula%20in%20B2%26nbsp%3B%3C%2FP%3E%3CP%3E%3DSUBSTITUTE(A2%2C%22.%22%2C%22%22)%2F1000%3C%2FP%3E%3CP%3Eyou%20can%20drag%20this%20formula%20to%20all%20the%20data%20rows.%26nbsp%3B%3C%2FP%3E%3CP%3Ehope%20this%20will%20work.%20if%20there%20further%20questions%2C%20please%20upload%20a%20sample%20data%20file.%20it%20will%20help%20to%20analyse%20the%20issues.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-778094%22%20slang%3D%22en-US%22%3ERe%3A%20txt%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-778094%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383566%22%20target%3D%22_blank%22%3E%40ronmas200%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-ruby%22%3E%3CCODE%3E%3D--REPLACE(A1%2CSEARCH(%22.%22%2CA1)%2C1%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20408px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124853i24A233059FA0F059%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
ronmas200
New Contributor

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.

Is there a special formula or?

Or must i chains some settings in the text wizard?

I don`t no what to do right now...

 

3 Replies

@ronmas200 

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.  

@Kodipady 

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.

@ronmas200 

As variant

=--REPLACE(A1,SEARCH(".",A1),1,"")

image.png