Forum Discussion
During paste csv, how to launch import wizard so the commas are recognized and columns formed.
- 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!
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!
- AliceDeanMar 28, 2019Copper Contributor
I don't know if this can be reversed? for example, I have three columns in excel. Last name, first name (with a comma) and then place next to third column. I am taking a list of graduates with their degrees and placing them into powerpoint program. I hope that this makes sense and that I replied to a thread that I thought was related
cellurl wrote: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!
- SergeiBaklanMar 28, 2019Diamond Contributor
Hi AliceDean ,
That is separate question, better to start new conversation for such.
To merge columns the easiest is with Power Query, but if only within the sheet please check https://www.ablebits.com/office-addins-blog/2013/10/13/merge-columns-excel-without-losing-data/
- AliceDeanMar 28, 2019Copper Contributor
Wow, that was a quick response and thank you. This is my first question and it was exactly what I needed. thank you. SergeiBaklan
- SergeiBaklanFeb 07, 2019Diamond Contributor
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
- cellurlFeb 07, 2019Copper Contributorhttps://trumpexcel.com/excel-text-to-columns-examples/