Excel: split comma separated values into rows

preview_player
Показать описание
The video offers a short tutorial on how to split comma separated values into rows in Excel.
Рекомендации по теме
Комментарии
Автор

Your splitting the values into columns not rows. Even the tab you highlight says "Text to columns"

handlerguy
Автор

How to count dates with comma. Like if I enter all these in cell A1 ..
1/2/21, 5/2/21, 8/2/21, 12/2/21, 15/2/21, 25/2/21 and type formula in B1. Result will be 6.

Sandeepkol
Автор

Bro doesn't even know the difference between columns and rows -__-

bellanya.