Forum Discussion
cellurl
Feb 07, 2019Copper Contributor
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 the first column.
Eg, during paste all I see is Paste-Special which doesn't bring up the import wizard.
just want this in the clipboard to launch the import wizard.
a,b,c
1,2,3
Is there anyway on Gods Green Earth that I have uncovered something that CANT be done in Excel?
That belongs in Revelations perhaps!
Thanks for any leads!
Jim in Memphis
- JKPieterseSilver ContributorYou could just paste and then click Data, Text to Columns...