P5 csv files

K
Karim Mounir 👤 Member for 20 years 2 months

yes, i think

open the excel file, select the data click on "Data" --> "Text to columns" -->

"Delimited" --> then select Comma and click on next.

K
Karim Mounir 👤 Member for 20 years 2 months

yes, i think

open the excel file, select the data click on "Data" --> "Text to columns" -->

"Delimited" --> then select Comma and click on next.

G
Giannis Kostis 👤 Member for 21 years

Hello Julie,



That is what i am doing, the but the results appear like that:



,,,,,,Late ,,,,,,,,"9444,44","20370,37","19444,44","21296,30","24074,07","46296,67"

,"53241,25","43991,24","63888,90","68518,53",



Any tip to transform them into a table ?



Thanks !

J
Julie Scully 👤 Member for 20 years 7 months

Hi Giannis



I usually open MS Excel and then open my file from there. Haven’t had any prolems to date.



Cheers

Julie

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts