You can also get the correct data without reopening the file by selecting the column which contains the data(which is the first column when opening a csv from windows explorer) and going to the "Data" tab and press the "text to columns" button which opens the same wizard as shown in the video
@FlexibleAssembly
4 жыл бұрын
That is an awesome tip that saves some time! Thank you for adding that.
@ensayogymequipment6458
3 жыл бұрын
Prior to my MS Office update, excel would always pop the "text import wizard" tab first when I open a csv file before showing the data. Now the wizard won't appear anymore when I open the same csv file, and the data are all compiled. I have to manually select the column every time now. Is there a way to reactivate the wizard or an option to make it appear again when opening csv files? Thanks mate
Пікірлер: 4