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.
Quote:
|
Just in case i get them as in screenshot 1, is there away to have them converted to be like the format in screenshot 2?
|
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.