Forum Discussion

cellurl's avatar
cellurl
Copper Contributor
Feb 07, 2019
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...
  • cellurl's avatar
    Feb 07, 2019

    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!

     

Resources