Text to collumns from the begginging

shoppingaim

New Member
Joined
Oct 9, 2013
Messages
1
I have a starnge problem with excell, when I open a csv file from my deveelopers it shows like a mess, but when they open the same file in their computer it shows the information arranged in collumns, the only way I can get it to look the same is to do the text to collumn move, the problem is that it somehow changes the file, for example if I first open the file in notepad the information is sperated with”, but if I then open it in excell and then do the text to collumn move, save it and then opens in in notepad again it has then changed to , between the info.

So is there some kind of setting I can do to make sure all the csv files open with the info arranged in collumns without have to do ”text to collumns move”?
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Check your regional settings in control panel to see if the list separator matches your CSV's separator
 
Upvote 0

Forum statistics

Threads
1,215,321
Messages
6,124,239
Members
449,149
Latest member
mwdbActuary

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top