SOLVED

Excel table

%3CLINGO-SUB%20id%3D%22lingo-sub-2819433%22%20slang%3D%22en-US%22%3EExcel%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2819433%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%26nbsp%3B%3CBR%20%2F%3EI%20have%20some%20data%20in%20my%20word%20document%20like%20this%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3Eanni%20%20%20%20%2020.3698%2011.580%200.5685%20%20-0.1422%20%20-0.9683%204262%0Arisposta%2046.2293%2033.345%200.7213%20%20%200.2241%20%20-1.3345%204262%0Apar%20%20%20%20%20%2037.9749%2018.765%200.4941%20%20%201.5388%20%20%201.8516%204262%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3Band%20i%20want%20to%20create%20a%20excel%20table%20from%20this%20data.%3CBR%20%2F%3EAny%20idea%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2819433%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2819488%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2819488%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1177585%22%20target%3D%22_blank%22%3E%40Mattia97%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECopy%2FPaste%20to%20Excel%3B%20Data-%26gt%3BText%20to%20Columns%20(space%20as%20delimiter)%3B%20Ctrl%2BL%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2819533%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2819533%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%20that%20was%20great%2C%20thanks%20.%3CBR%20%2F%3ELast%20thing%2C%20the%20format%20(only%20for%20the%20first%20column)%20is%20wrong.%3CBR%20%2F%3EExample%3A%20in%20my%20previous%20comment%2020.3698%20is%20formatted%20like%20203.698%2C%2046.2293%20is%20formatted%20462.293%20etc..%20while%20the%20other%20data%20are%20correct%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone, 
I have some data in my word document like this: 

 

anni     20.3698 11.580 0.5685  -0.1422  -0.9683 4262
risposta 46.2293 33.345 0.7213   0.2241  -1.3345 4262
par      37.9749 18.765 0.4941   1.5388   1.8516 4262

 

 and i want to create a excel table from this data.
Any idea? Thanks

3 Replies
best response confirmed by Mattia97 (New Contributor)
Solution

@Mattia97 

Copy/Paste to Excel; Data->Text to Columns (space as delimiter); Ctrl+L

@Sergei Baklan that was great, thanks .
Last thing, the format (only for the first column) is wrong.
Example: in my previous comment 20.3698 is formatted like 203.698, 46.2293 is formatted 462.293 etc.. while the other data are correct

@Mattia97 

Please check on third step of the wizard which decimal/thousand separators are used

image.png