Home

During paste csv, how to launch import wizard so the commas are recognized and columns formed.

cellurl
New Contributor

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

 

1 Reply
You could just paste and then click Data, Text to Columns...
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies