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!
