Excel: Convert Comma Separated Text into Columns

preview_player
Показать описание
Program: Excel 2010

Instructions:
= Copy intended comma-separated text from source (pdf, online, word, etc)
= Paste to the intended first cell in excel
= Select cell containing comma-separated text
= Go to "Data" and select "Text to Columns"
= Choose "Delimited" and click "next"
= Choose "comma" and click "finish"
= Result: each comma separated value has now been placed into separate columns

Рекомендации по теме
Комментарии
Автор

this is Convert Comma Separated Text into ROW, not columns

alirj