SOLVED

Excel table

Copper 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 (Copper 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

1 best response

Accepted Solutions
best response confirmed by Mattia97 (Copper Contributor)
Solution

@Mattia97 

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

View solution in original post