Hi Jamal,

If you're opening the same file using the same method on the same PC, it's pretty strange that the delimiter would be honoured on some occasions but not others. It could possibly be due to the list separator not being set correctly in the Windows regional settings.
Yes, certainly. You can select column A > Data > Text to Columns. Then the method is very similar to the import wizard steps I mentioned before.

Thank you for the prompt answer Colin.

That's correct that i use the same method to open the file but not the same computer!

for the time being, I'm using my lab top, i'll check the setting of the "List separator" of the windows in the other PC and let you know.

is this the only reason for which i got the appearance shown in the screenshot 1?

regards

Jamal

Attached Images

Clip_293.jpg (80.7 KB, 12 views)

Hi Jamal,
Ah ok, that sounds a little less strange then!
If the CSV files are associated with Excel (when you double click on them in Windows Explorer your computer knows that it should open them into Excel), then the only thing I can think of is the regional settings list separator.