Google Sheets: Split text to columns to have one type of data per cell
As a general rule, each column should have only one type of data in it, and, optimally, each cell should only have one value. If cells/columns have too many contents, you can't easily work with the data in sorting, filtering, or formulas. For example, you can't as easily make a chart of project status if status and date are in one cell together. [Follow along with a copy of the demo sheet and slides below]
If you have more than one item in a cell, you can try Google Sheets Split text to columns tool to automatically split the contents into separate cells.
1) Add extra column(s) to the right of data
2) Highlight data to split
3) Data, Split text to columns
4) Specify separator, and data will split into the columns
Copy Demo Sheet: https://doittraining.page.link/better...
Slides: https://docs.google.com/presentation/...
Смотрите видео Google Sheets: Split text to columns to have one type of data per cell онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь DoIT Training at Stony Brook University 20 Сентябрь 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 30,472 раз и оно понравилось 42 людям.