Forum Discussion
Solved
During paste csv, how to launch import wizard so the commas are recognized and columns formed.
I dont want to create an intermediate file. I just want to directly take csv from anywhere, perhaps notepad, perhaps notepad++ Then copy it. Then in excel, paste it and not have it all jam into th...
i found it.
1. just paste it all jammed into 1 column
2. Hit control-A to highlight everything.
3. Hit Data->Text-to-Columns. That brings up the import wizard! Yipee
Boom!
i found it.
1. just paste it all jammed into 1 column
2. Hit control-A to highlight everything.
3. Hit Data->Text-to-Columns. That brings up the import wizard! Yipee
Boom!
You may skip one step. After pasting into the sheet you may see small icon like here
Press Ctrl, Arrow Down, Enter or expand by mouse to start the wizard